RE: inserting into DATE colum

From: Vadim Gorbounov <vgorbounov_at_simplyengineering.com>
Date: Mon, 09 Apr 2001 10:41:45 -0700
Message-ID: <F001.002E576D.20010409104025@fatcity.com>

Hello, Helmut,

As far as I understand, you have a set of string-formatted data intended to be stored as DATE datatype. If these strings have different formats, you have to specify the format in sql sentence:

String has DD/MM/YYYY format: insert into tbtable(fldDate) values ( to_date(<YOUR DATA> , 'DD/MM/YYYY'));
String has DD/MM/YYYY HH:MI:SS format: insert into tbtable(fldDate) values ( to_date(<YOUR DATA> , 'DD/MM/YYYY HH:MI:SS'));

The only condition - <YOUR DATA> should match format pattern. Internaly Oracle stores DATA type in the same format in both cases.

Format pattern could be omitted, if it is default format of the session (easy to find select sysdate from dual;)

Best regards,
Vadim Gorbounov
Oracle DBA

-----Original Message-----
Sent: Monday, April 09, 2001 2:01 PM
To: Multiple recipients of list ORACLE-L

Hi!

I have a question concerning inserting data in a DATE column. The deal is that sometimes, I just wanna insert DD/MM/YYYY and in other cases I wanna insert DD/MM/YYYY HH:MI:SS in the same column.

How can I handle that?

insert into TbTABLE values (To_Date('03/09/2001'), To_Date('03/09/2001'),
                            To_Date('03/09/2001'), To_Date('03/09/2001'),
                            To_Date('03/09/2001 11:11:11'))

Do I need to supply formatting information for the date to the insert statement?

This is 8.1.6 on Win2k.

Thanks,
Helmut

--

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

Author: Helmut Daiminger
INET: hdaiminger_at_vivonet.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

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

Author: Vadim Gorbounov
INET: vgorbounov_at_simplyengineering.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------