Name

datestring_GMT — convert a timestamp to external format string in GMT

Synopsis

datestring_GMT ( in dt datetime );
 

Description

Converts the local datetime to GMT and returns its external representation as a string.

Parameters

dt

A datetime value.

Return values

A VARCHAR containing the external representation.

Examples

Example 24.75. Example with datestring_GMT

We are at central european time zone CET(GMT+1).

SQL> use Demo;

 Done. -- 3 msec.
 SQL> select (datestring_GMT (stringdate ('2000-01-01 22:00')));
 callret
 VARCHAR
 _______________________________________________________________________________

 2000-01-01 21:00:00.000000

 1 Rows. -- 45 msec.


See Also

datestring , stringdate

The discussion of TIMESTAMP datatype in section Database Concepts of the documentation.