| Inserting dates [message #374785] |
Mon, 02 July 2001 10:38  |
Purvi
Messages: 1
Registered: July 2001
|
Junior Member |
|
|
Hi,
I am trying to insert date values into a table but Iam getting error messages. Can anyone tell me the proper syntax of it.
Thanks
|
|
|
|
| Re: Inserting dates [message #374787 is a reply to message #374785] |
Mon, 02 July 2001 10:42  |
sverch
Messages: 582
Registered: December 2000
|
Senior Member |
|
|
Can you be more specific please?
What message do you get, what is your column's datatype and what value format are you trying to insert?
|
|
|
|
| Re: Inserting dates [message #374812 is a reply to message #374785] |
Wed, 04 July 2001 05:43 |
sonia
Messages: 22
Registered: March 2001
|
Junior Member |
|
|
Case 1: When u insert date in the default format,u just say :
insert into test1 values('23-jul-99')
Case2:when u r trying to insert date not in the default format,u have to use to_date function.
insert into test1 values(to_date('31/07/1999','dd/mm/yyyy'))
In both of the above cases,I assume that the column datatype is Date while table creation.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
