Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: select to_date('2004','YYYY') NOT Jan 1 2004
On Wed, 24 Mar 2004 13:40:10 -0500, "Jarson" <jarsonk_at_nospam.com>
wrote:
>You shouldn't have to
ignorance is bliss. Any element you don't specify in to_char defaults
to the sysdate, as documented.
You should have TRUNCed the date to YYYY
-- Sybrand Bakker, Senior Oracle DBAReceived on Wed Mar 24 2004 - 17:04:43 CST