Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Need a function to return GMT time

Re: Need a function to return GMT time

From: Jerome Vitalis <vitalis..._at_gmail.com>
Date: 12 Nov 2007 15:22:47 GMT
Message-ID: <47386fc7$0$5260$426a74cc@news.free.fr>


DA Morgan wrote:

> But why not make it easy an just do the following:
> ALTER SYSTEM SET TIME_ZONE = '-0:00';
Because it will not work? ;-)
I guess you meant "alter database" but it is not always possible to use it (e.g. with TIMESTAMP WITH LOCAL TIME ZONE columns.)



échangez opinions et commentaires dans les forums de discussion. http://www.usenetgratuit.com/ Received on Mon Nov 12 2007 - 09:22:47 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US