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

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