Date and time literal values are enclosed in single quotion marks ('value').

  • The format for a Date literal is DATE'date'.
  • The format for a Time literal is TIME'time'.
  • The format for a Timestamp literal is TIMESTAMP'ts'.