SWITCHOFFSET 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 » SQL Anywhere Server - SQL Reference » SQL functions » Functions

SWITCHOFFSET function [Date and time]

Returns a TIMESTAMP WITH TIME ZONE value that is converted from its original time zone offset to the specified time zone offset.

Syntax

SWITCHOFFSET( tmz-expression, time-zone-offset )

Parameters

tmz-expression The TIMESTAMP WITH TIME ZONE value to be converted.

time-zone-offset The time zone offset of the result. The value can be an integer representing the minutes before or after Coordinated Universal Time (UTC), a string in the form { + | - } hh:nn, or 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 © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0