Date, time [message #1974] |
Thu, 13 June 2002 23:26 |
Geir
Messages: 1 Registered: June 2002
|
Junior Member |
|
|
Hi
I'm trying to insert the following into a date field:
(a string with date and time information)
Date: 13.06.06 Time:13.05.20 (yyyymmdd hh.mm.ss)
How can this be done?
|
|
|
Re: Date, time [message #1976 is a reply to message #1974] |
Fri, 14 June 2002 03:26 |
Balaji
Messages: 102 Registered: October 2000
|
Senior Member |
|
|
Hi
Use the date format function to insert.
ex
insert into table1 values(to_date('20010510 14.05.20','yyyymmdd hh24.mi.ss'));
balaji
|
|
|