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 answers

  1. 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
    1. makelzauvic
       
      Thank you for this response!!!!
      0
    2. Micmic
       
      Thank you
      0