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
Example24.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