Expressions passed to this function must have one of the following data types:
- DATE
- TIMESTAMP
- TIMESTAMP WITH TIME ZONE
Because TIMESTAMP values are stored in UTC time within the database and lack a time zone, the session time zone is used to interpret the time stamp value within the function. For TIMESTAMP WITH TIME ZONE values, the time zone component is used to interpret the time stamp value within the function.