| insert date [message #371764] |
Mon, 04 December 2000 07:51  |
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  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
