Re: Date Format

From: Jim Smith <jim_at_jimsmith.demon.co.uk>
Date: Wed, 22 Mar 2006 11:51:27 +0000
Message-ID: <z9iJ98j$oTIEFweg@jimsmith.demon.co.uk>

In message <1143023034.096177.172250_at_g10g2000cwb.googlegroups.com>, ajay.bisht_at_gmail.com writes
>How can we convert 20060321T13:53:28671 into date format
>

Use the to_date() or the to_timestamp() function depending on version.

<http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14200/functi ons.htm#i1482196>

If the 28761 is milliseconds, then you need to use to_timestamp because dates have a resolution of one second.

-- 
Jim Smith
I'm afraid you've mistaken me for someone who gives a damn.

Received on Wed Mar 22 2006 - 05:51:27 CST