Thursday, July 11, 2013

to_char or to_date which one to use

Our developper ask me often which on to use between to_char and to_date, i think they should
  • Use to_char to DISPLAY a date datatype 
  • Use to_date to STORE a date datatype in a row
to_char converts a date to a varchar and to_date converts a varchar to a date