Home » RDBMS Server » Server Administration » insert date
insert date [message #371764] Mon, 04 December 2000 07:51 Go to next message
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
Re: insert date [message #371780 is a reply to message #371764] Mon, 04 December 2000 18:38 Go to previous message
SQL_Tuner
Messages: 8
Registered: November 2000
Junior Member
Hi! Your question is a little unclear.

This works:

update emp
set birthday = to_date ('12/1/1977', 'MM/DD/YYYY')
where emp_name = 'SQL_TUNER';

Or:

insert into emp (emp_name, birthday)
values ('SQL_TUNER', to_date ('12/1/1977', 'MM/DD/YYYY');

As long as birthday is a date column.

Regards,
ST
Previous Topic: Re: storing time and date
Next Topic: PL/SQL Table - Please HELP!!
Goto Forum:
  


Current Time: Sun Dec 22 19:38:37 CST 2024