TO_DATE

Returns the provided number as a date

Usage examples 

  • TO_DATE(15)

  • TO_DATE(tableA.fieldB)

Syntax 

TO_DATE ( date_serial_num )

  • date_serial_num - the date serial number from which to calculate the date

Returns 

string - the date representation of the number.

Functions reference