RE: update year in date column

From: <Stephen.Lee_at_DTAG.Com>
Date: Tue, 23 Mar 2004 15:13:43 -0600
Message-ID: <D6339830FC73944E889CC3CEADDB205B079092AE@bu-dtagpo1.tracs.com>

Here the original year on a was 2002.

update crap2 set a =
to_date(to_char(a,'MM/DD')||'/'||replace(to_char(a,'YYYY'),'2002','3002'),'M M/DD/YYYY')
> -----Original Message-----
> Thought I'd be clever and subtract 1000 from the date.
> This works, but I don't know how to get it formatted
> back into a date.

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Tue Mar 23 2004 - 16:29:35 CST