|
-
 Originally Posted by cjard
select to_timestamp('2006-08-21-16.37.30.459999', 'YYYY-MM-DD-HH24.MI.SS.FF6') from dual
The above give timestamp values in following format:
31-DEC-99 11.59.59.999999000 PM
However, the requirement is to have timestamp in the following format:
9999-12-31-23.59.59.999999
How can this be done without making changes to NLS_TIMESTAMP_FORMAT?
Thanks.
Last edited by ggnanaraj; 08-22-2006 at 01:59 AM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote