RE: inserting into DATE colum

A database table date column always stores the date and time. For example is the current date and time was 09-apr-2001 at 14:23.32 .

INSERT INTO MY_TABLE(MY_DATE) VALUES(SYSDATE); This would store the entire date and time.

INSERT INTO MY_TABLE(MY_DATE) VALUES(TRUNC(SYSDATE)); This would store the date with a time of 00:00.00;

If you want to insert a date that is formatted in a varchar2 field into a date field you would do the following.
insert into TbTABLE values (To_Date('03/09/2001','MM-DD-YYYY'),   To_Date('03/09/2001','MM/DD/YYYY'),

                            To_Date('03/09/2001 11:11:11','MM/DD/YYYY HH:MI:SS))

>>> prakash.bala_at_cingular.com 04/09/01 02:26PM >>>
Helmut,

If you want to insert the date in any format other than 'DD-MON-YYYY' or 'DD-MON-YY', you need to specify the date format when you use the to_date function.

Prakash

-----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: Bala, Prakash
  INET: prakash.bala_at_cingular.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: William Beilstein
  INET: BeilstWH_at_obg.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).