| Datetime [message #56051] |
Tue, 04 March 2003 08:28  |
snreddy
Messages: 16
Registered: January 2003
|
Junior Member |
|
|
|
How can i create and Insert values a column with datatype as datetime in oracle 8.1.7.
|
|
|
|
| Re: Datetime [message #56052 is a reply to message #56051] |
Tue, 04 March 2003 08:37  |
Suresh
Messages: 189
Registered: December 1998
|
Senior Member |
|
|
Here is the Ans:
To create:
cretae table test(sno number, date_of_birth date);
To insert:
insert into test values(1,'28-jan-2003');
please try this ...if u have any probles mail me back.
Note: the date format depens upon your NLS date format.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
