Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> How to solve probably a very simple DATE problem?
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 Received on Fri Sep 14 2007 - 09:45:05 CDT
![]() |
![]() |