dbtimezone returns a string. From the online help:
The DBTIMEZONE function returns the value of the database time zone. The
return type is a time zone offset (a character type in the format
'[+|-]TZH:TZM') or a time zone region name, depending on how the user
specified the database time zone value in the most recent CREATE DATABASE or
ALTER DATABASE statement
--
Terry Dykstra
Canadian Forest Oil Ltd.
"ahillman3" <Allen_Hillman_at_technologist.com> wrote in message
news:3be19051$1_at_usenetgateway.com...
> select sysdate-(dbtimezone/24) from dual;
>
> This returns: ORA-00907: missing right parenthisis
>
> What am I doing wrong?
>
> Is there a configuration problem?
>
> Thanks for the continued assistance.
>
> Allen H.
>
>
>
> --
> Posted via dBforums
> http://dbforums.com
>
Received on Thu Nov 01 2001 - 12:54:08 CST
