Name

forget_timezone — returns its first argument as a timezoned value

Synopsis

datetime forget_timezone ( in dt datetime ,
  in ignore_timezone integer );
 

Description

The function returns its first argument as a timezoned value. If the first argument is timezoneless then it is returned unchanged. If the first argument is timezoned and second argument is missing or zero then the result is timezoneless value that "looks like" local time notation. If the first argument is timezoned and second argument is nonzero then the value is first made GMT and then it becomes timezoneless.

Parameters

dt

Datetime value.

ignore_timezone

Flag

Examples

Example 24.58. Simple example

SQL> select cast (forget_timezone (cast ('1999-12-31 11:59+02:00' as datetime)) as varchar);
VARCHAR
'1999-12-31 11:59:00'
No. of rows in result: 1