Top

Name

is_timezoneless — returns 1 for timezoneless arguments, zero for timezoned

Synopsis

datetime is_timezoneless ( in dt datetime );
 

Description

The function returns 1 for timezoneless arguments, zero for timezoned.

Parameters

dt

Datetime value.

Examples

Example 24.59. Simple example

SQL> select is_timezoneless (cast ('1999-12-31 11:59' as datetime));
INTEGER
 0
No. of rows in result: 1