开发者

Convert VARCHAR2 to TIMESTAMP in Oracle

I have a VARCHAR2 value in the format '14-SEP-11 12.33.48.537150 AM' and I need to convert this to a TIMESTAMP as is. That is like,

SELECT TO_DATE('14-SEP-11 12.3开发者_JAVA技巧3.48.537150 AM', '<format_string>') FROM DUAL;

I want the return from the above query to be '14-SEP-11 12.33.48.537150 AM' in TIMESTAMP data format.

What should be the 'format_string' for this.

Please help since I tried many things but none works.. :(

I am using Oracle 11gR2.

Thanks.


DATE and TIMESTAMP are two different datatypes. So you need to use the correct conversion function for each, which in your case would be TO_TIMESTAMP().

SELECT TO_TIMESTAMP('14-SEP-11 12.33.48.537150 AM', 'DD-MON-RR HH:MI:SS.FF AM') 
FROM DUAL;


select from_tz(to_timestamp('14-SEP-11 12.33.48.537150 PM', 'DD-Mon-RR HH.MI.SS.FF AM'), 'EUROPE/LONDON') from dual
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜