Time Strings

Learn about the time string function.

Syntax

A time string can be in any of these formats:
  1. YYYY-MM-DD

  2. YYYY-MM-DD HH:MM

  3. YYYY-MM-DD HH:MM:SS

  4. YYYY-MM-DD HH:MM:SS.SSS

  5. HH:MM

  6. HH:MM:SS

  7. HH:MM:SS.SSS

  8. now

  9. DDDD.DDDD

Note:

Formats 5 – 7 that specify only a time assume a date of 2000-01-01. Format 8 is converted into the current date and time, using Universal Coordinated Time (UTC). Format 9 is the Julian day number expressed as a floating point value.

Examples