YYYY
: Four-digit yearMM
: One / two-digit monthDD
: One / two-digit dayHH
: One / two-digit hour (valid values from 00 to 23)MM
: One / two-digit minutes (valid values from 00 to 59)SS
: One / two-digit seconds (valid values from 00 to 59)[.SSSSSS]
: Up to six fractional digits (microsecond precision)SELECT
statement to get all records of the visitors table:
60
, which exceeds the standard seconds format.
select
statement below:
00
as 60
, which adds 1 minute to the minutes’ value.
AT TIME ZONE
operator enables us to convert the input timestamp to the target time zone specified in the query. Additionally, the timestamp you inputted will always be presented in the user’s local timezone (currently set as UTC).
AT TIME ZONE
operator, you can follow this syntax:
input_timestamp
: This represents the date and time value you want to convert. The user’s time zone is fixed to UTC.TIME_ZONE
: The target time zone to which the timestamp will be converted. visitDate
displays the timestamps without a time zone, and visitDateMST
stores the timestamps converted to the MST time zone.