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

From: gazzag <gareth_at_jamms.org>
Date: Fri, 14 Sep 2007 08:42:27 -0700
Message-ID: <1189784547.121474.260400@22g2000hsm.googlegroups.com>

On 14 Sep, 15:45, harryajh <harry..._at_yahoo.co.uk> 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

In a SQL*Plus session:

SQL> show parameter nls

Then, http://download.oracle.com/docs/cd/B10501_01/server.920/a96529/toc.htm

HTH -g Received on Fri Sep 14 2007 - 10:42:27 CDT