Home » Infrastructure » Unix » Re: Oracle date format - Ans from Shrikant Potnis
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
Previous Topic: how can i prevent some ftp commands
Next Topic: Oralce9i on Solaris 8 installation problem
Goto Forum:
  


Current Time: Tue May 21 16:01:26 CDT 2024