TODATETIMEOFFSET function [Date and time]

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

SQL Anywhere 12.0.0 (Français) » UltraLite - Database Management and Reference » UltraLite SQL reference » UltraLite 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

Discuter à propos de cette page dans DocCommentXchange.

Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0