Hi Elke,
                Thanks, UTCDIFF was what I was looking for. "Select
UTCDIFF from dual" works in oracle mode. Do u know if this is actually
portable to ORACLE?? 
Regards,
Ajit

-----Original Message-----
From: Zabach, Elke [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, June 30, 2004 12:33 PM
To: 'Ajit Aranha'; [EMAIL PROTECTED]
Subject: AW: SQLMODE oracle and timezone

Ajit Aranha wrote:
> 
> Hi,
>  Is there a way to get timezone or GMT offset of the database
> installation? ( is there a soln  in oracle mode?)

Are we talking about UTCDATE / TIMEZONE as described here?
http://dev.mysql.com/doc/maxdb/en/15/1a2bb4b44d11d2a97100a0c9449261/fram
eset.htm

Elke
SAP Labs Berlin

> Regards,
> Ajit

-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]



-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to