TODATETIMEOFFSET function [Date and time]

TODATETIMEOFFSET function [Date and time]

Converts a TIMESTAMP value to a TIME STAMP WITH TIME ZONE value using the specified time zone offset.

Syntax

TODATETIMEOFFSET( timestamp-expression, time-zone-offset )

Parameters

timestamp-expression The TIMESTAMP expression to be converted.

time-zone-offset The time zone offset. The value can be an INTEGER representing minutes before or after UTC, a VARCHAR string in the form of { + | - }hh:nn, or the string "Z" for the Zulu Time Zone. The Zulu Time Zone is the same time zone as UTC.

Returns

See also

Standards and compatibility

Example

Discuss this page in DocCommentXchange.

Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1