Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to solve probably a very simple DATE problem?
thanks for that, shows "+01:00" which I assume is because we're in BST?
does that mean though that the values held in DATE fields will be held as "00:00"?
this is the bit that's confusing me - are all oracle date/timestamp fields anywhere in the world held in the same way & just displayed differently depending your location?
"DA Morgan" <damorgan_at_psoug.org> wrote in message
news:1189785911.621681_at_bubbleator.drizzle.com...
> harryajh wrote:
> > Using Oracle 9i
> >
> > I have to compare a DATE column value with a file last modified date
> > held on a disk system.
> >
> > In Java I can use the SimpleDateFormat() which adjusts the file date
> > (which may or may not include day light saving) to GMT which is fine!
> >
> > My question is how can I tell if the DATE columns in the Oracle
> > database are also in GMT? - is there a SQL statement I can run? are
> > they always stored in GMT?
> >
> > Any ideas?
> >
> > thanks in advance
> >
> > harry
>
> SELECT SESSIONTIMEZONE FROM dual;
>
> You will find a complete list of Oracle functions in Morgan's
> Library at www.psoug.org. At the top of the Library page click
> on "Built-in Functions."
> --
> Daniel A. Morgan
> University of Washington
> damorgan_at_x.washington.edu (replace x with u to respond)
> Puget Sound Oracle Users Group
> www.psoug.org
Received on Sat Sep 15 2007 - 08:49:46 CDT