toLocal

Returns the string representing a timestamp with time zone resulting from adjusting "string_expression" to the time zone of the operating system. Note that the macro function timestampMask () can be used to trim the output.

Syntax

toLocal ( string_expression )

Example 1

# toLocal ( '2005-11-01 17:00:00.000-00:00' ) # where OS local time 
zone is -05:00

Result

2005-11-01 12:00:00.000000000-05:00

Example 2

# timestampMask ( toLocal ( '2005-11-01 17:00:00.000-00:00' ) ,
 'yyyy-mm-dd hh:mm:ss+hh:mm' ) # where OS local time zone is -05:00

Result

2005-11-01 12:00:00-05:00

Example 3

# toLocal ( '2005-11-01 13:30:00.000-03:30' ) # where OS local time 
zone is -05:00

Result

2005-11-01 12:00:00.000000000-05:00