Functions
TO_DATE
Converts a number to a date serial value
Try it
When to use it
When should I use TO_DATE?
Use TO_DATE to convert a numeric serial value into a date type so that date arithmetic and date-formatting functions treat it as a date rather than a plain number.
Used in
Syntax
TO_DATE(value)Examples
=TO_DATE(1) // => 1
=TO_DATE(25405) // => 25405
=TO_DATE(44927) // => 44927