TODATETIMEOFFSET function [Date and time]

Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - SQL Reference » SQL functions » Functions

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 © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0