|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Dell PowerEdge Servers
|
|
#1
July 10th, 2002, 06:52 PM
|
||||
|
||||
|
Oracle and dates
Now, I'm just getting introduced to Oracle. I'm migrating from MySQL, which right now seems so simple and Oracle seems very complicated. Anyway, I have a couple of questions about dates in Oracle. In MySQL, dates had to be entered into a field in the format "YYYY-MM-DD" and then you could use this date function called DATE_FORMAT() to format the date in pretty much anyway you want. Anyway, what is the default Oracle date format and what statement would I have to use to format a date to "March, 1999" or "March 19, 1999" for example?
|
|
#2
July 10th, 2002, 07:07 PM
|
|||
|
|||
|
The standard date format in Oracle is like this
11-JUL-2002 You could use this to change the date format TO_DATE('01 July 2002','DD Month YYYY') or TO_DATE('January 15, 1989, 11:00A.M.', 'Month dd, YYYY, HH:MI A.M.') An explanation of the TO_DATE function can be found here: http://info-it.umsystem.edu/oracle/...slr.2.0173.html wabirdman
__________________
Real programmers code in binary Last edited by wabirdman : July 10th, 2002 at 07:18 PM.
|
|
| Viewing: Dev Shed Forums > Databases > Database Management > Oracle and dates |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
