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

Home -> Community -> Usenet -> c.d.o.server -> Re: How to solve probably a very simple DATE problem?

Re: How to solve probably a very simple DATE problem?

From: DA Morgan <damorgan_at_psoug.org>
Date: Fri, 14 Sep 2007 09:05:20 -0700
Message-ID: <1189785911.621681@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 Fri Sep 14 2007 - 11:05:20 CDT

Original text of this message

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