Converts a TIMESTAMP value to a TIME STAMP WITH TIME ZONE value using the specified time zone offset.
SyntaxTODATETIMEOFFSET( timestamp-expression, time-zone-offset )
Parameterstimestamp-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.
ReturnsTIMESTAMP WITH TIME ZONE
See also Standards and compatibilitySQL/2008 Vendor extension.
ExampleThe following example converts a TIMESTAMP value to a TIMESTAMP WITH TIME ZONE value.
SELECT CAST('2009-04-03 14:45:12.123' AS TIMESTAMP) AS orig,
TODATETIMEOFFSET (orig,'+11:00'); |
 |
Discuss this page in DocCommentXchange.
|
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1 |