TZSERIAL
Drops the zone, returning the wall-clock time as a plain date serial
Try it
When to use it
When should I use TZSERIAL instead of reading the value directly from TZDATETIME?
Use TZSERIAL when you need to pass a zone-aware value into ordinary date/time functions like YEAR(), MONTH(), HOUR(), or MINUTE() that only accept plain serial numbers, not zoned values.
What is the difference between TZSERIAL and TZSTRING?
TZSERIAL drops the zone and returns the wall-clock time as a numeric serial number suitable for arithmetic and built-in date functions, while TZSTRING returns a human-readable text representation of the zoned datetime.
What happens to the timezone offset when I call TZSERIAL?
The offset is discarded entirely. TZSERIAL returns the local wall-clock time as-is, so 09:30 in Tokyo and 09:30 in London both return the same serial number representing 09:30.
Use cases
Get the day of the month from a zoned value
Calculate days remaining in the month using a zoned datetime
Used in
operations · finance · engineering
Syntax
TZSERIAL(zoned)