View original (French)

Oracle: data type for DATE + TIME?

Solved
Nico -  
 Micmic -
Hello,

Is there a data type in Oracle related to date and time, like DATETIME in MySQL?
If not, how can you have a precise notion of time (date, hour + minute and second) in an Oracle field???

Thank you for your response.

Nico

2 réponses

Réponse 1 / 2
kwisteul
 
To retrieve a value from the MYDATE field of type date:
TO_CHAR(MYDATE,'DD-MM-YYYY HH24:MI:SS')
To insert a date into MYDATE:
TO_DATE('01-01-2004 13:38:11','DD-MM-YYYY HH24:MI:SS')
30
makelzauvic
 
Thank you for this response!!!!
0
Micmic
 
Thank you
0