Re: date storage format Personal Oracle 7.3

From: news.infonie.fr <x_at_x.fr>
Date: Mon, 1 Jun 1998 09:47:41 +0200
Message-ID: <896687348.551827@si1-paris>

Rich Scheipe a écrit dans le message <6kjjvg$sla_at_sjx-ixn6.ix.netcom.com>...
>Trying to figure out how to store a four character date in Personal Oracle
>7.3.
>Any help appreciated.
>Thanks,
>Rich Scheipe
>
>

four character date means YYYY or MMDD ? first, you have to define your NLS_DATE_FORMAT ( with YYYYMMDD for instance ) and you can use TO_CHAR and TO_DATE in you SQL command.

INSERT INTO EMP ( BIRTHDT ) VALUES ( TO_DATE( '19700323', 'YYYY') ); Good luck. Denis. Received on Mon Jun 01 1998 - 02:47:41 CDT