可以使用cast强制转换的函数实现oracle中date数据类型与timestamp数据类型的转换
SQL> select hiredate from emp;
HIREDATE
------------
17-DEC-80
20-FEB-81
22-FEB-81
02-APR-81
28-SEP-81
01-MAY-81
09-JUN-81
19-APR-87
17-NOV-81
08-SEP-81
23-MAY-87
HIREDATE
------------
03-DEC-81
03-DEC-81
23-JAN-82
14 rows selected.
SQL> select cast(hiredate as timestamp) from emp;
CAST(HIREDATEASTIMESTAMP)
---------------------------------------------------------------------------
17-DEC-80 12.00.00.000000 AM
20-FEB-81 12.00.00.000000 AM
22-FEB-81 12.00.00.000000 AM
02-APR-81 12.00.00.000000 AM
28-SEP-81 12.00.00.000000 AM
01-MAY-81 12.00.00.000000 AM
09-JUN-81 12.00.00.000000 AM
19-APR-87 12.00.00.000000 AM
17-NOV-81 12.00.00.000000 AM
08-SEP-81 12.00.00.000000 AM
23-MAY-87 12.00.00.000000 AM
CAST(HIREDATEASTIMESTAMP)
---------------------------------------------------------------------------
03-DEC-81 12.00.00.000000 AM
03-DEC-81 12.00.00.000000 AM
23-JAN-82 12.00.00.000000 AM
14 rows selected.
SQL> select hiredate from emp;
HIREDATE
------------
17-DEC-80
20-FEB-81
22-FEB-81
02-APR-81
28-SEP-81
01-MAY-81
09-JUN-81
19-APR-87
17-NOV-81
08-SEP-81
23-MAY-87
HIREDATE
------------
03-DEC-81
03-DEC-81
23-JAN-82
14 rows selected.
SQL> select cast(hiredate as timestamp) from emp;
CAST(HIREDATEASTIMESTAMP)
---------------------------------------------------------------------------
17-DEC-80 12.00.00.000000 AM
20-FEB-81 12.00.00.000000 AM
22-FEB-81 12.00.00.000000 AM
02-APR-81 12.00.00.000000 AM
28-SEP-81 12.00.00.000000 AM
01-MAY-81 12.00.00.000000 AM
09-JUN-81 12.00.00.000000 AM
19-APR-87 12.00.00.000000 AM
17-NOV-81 12.00.00.000000 AM
08-SEP-81 12.00.00.000000 AM
23-MAY-87 12.00.00.000000 AM
CAST(HIREDATEASTIMESTAMP)
---------------------------------------------------------------------------
03-DEC-81 12.00.00.000000 AM
03-DEC-81 12.00.00.000000 AM
23-JAN-82 12.00.00.000000 AM
14 rows selected.
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/28803801/viewspace-777181/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/28803801/viewspace-777181/