OraFAQ Forum: Server Administration

Mon, 04 December 2000 07:56

Mandarapu Srinivas
Messages: 6
Registered: September 2000

Junior Member

is it posibble to insert date field as '12/09/1988'
(mm/dd/yyyy) format if so
how to insert pls give an example
thank u
srinu

Mon, 04 December 2000 08:06

Vedha
Messages: 4
Registered: October 2000

Junior Member

Try this.
insert into test values(to_date('12/09/1988','mm/dd/yyyy'));
Let me know if you have any questions.
Vedha

Wed, 07 February 2001 00:38

Khan
Messages: 8
Registered: February 2001

Junior Member

I have used

insert into MyTable values('khan','02-FEB-99');

***look the date format used:: 02-FEB-99

Let me know if this works for you.

Khan

Previous Topic:	How do I run an sql program in Oracle?
Next Topic:	sql query taking too much of time

Goto Forum:

]

Current Time: Wed May 15 21:03:23 CDT 2024