CONVERT TIME STAMP

Reference

Syntax

CONVERT { TIME STAMP time_stamp TIME ZONE tz
          INTO [DATE dat] [TIME tim] [DAYLIGHT SAVING TIME dst] }
      | { DATE dat [TIME tim [DAYLIGHT SAVING TIME dst]]
          INTO TIME STAMP time_stamp TIME ZONE tz }.

Effect

Either converts a date and time specification into dat and tim with reference to a tz time zone in a UTC time stamp and returns the result in time_stamp, or it converts a UTC time stamp in time_stamp into date and time specifications and returns the results in dat and tim.

Additions

• DAYLIGHT SAVING TIME dst
  For CONVERT DATE, specifies whether the time specification is in the summer time. For CONVERT TIME STAMP, specifies whether the time stamp is in the summer time.