| Re: Oracle date format - Ans from Shrikant Potnis [message #97825] |
Tue, 18 February 2003 20:27 |
Ramesh Malapati
Messages: 1
Registered: February 2003
|
Junior Member |
|
|
You can have date format having 'yy' as follows :
insert into addresses values
(1006,to_date('02/18/03','mm/dd/yy'),125,'Moony Rd','Mount Olive','Stanhope','NJ','07874')
or insert into addresses values
(1005,to_date('18/02/03','dd/mm/yy'),125,'Moony Rd','Mount Olive','Stanhope','NJ','07874')
or insert into addresses values
(1004,to_date('03/02/18','yy/mm/dd'),125,'Moony Rd','Mount Olive','Stanhope','NJ','07874')
By the way you can go to following site and you will get every thing about date format.
http://www-db.stanford.edu/~ullman/fcdb/oracle/or-time.html
from Shrikant Potnis
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
