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

Home -> Community -> Usenet -> c.d.o.misc -> oracle date

oracle date

From: Peter Valicek <Sonny2_at_gmx.net>
Date: Thu, 03 Apr 2003 22:45:04 +0200
Message-ID: <pan.2003.04.03.20.45.04.397613@gmx.net> 





Hello NG,



I use an oracle DB, to getting infotmations. But the timestamps from value
date has only the format 13-MAR-2003 for example.
I know to get the formated date like to_char(.....) but, as well they
stored by GMT +0.


So how can I get the correct time by my GMT, which is GMT+1 ( MET ).



Thx, in forward.



-Peter

-- 



[_Linux is like a wigwam,


        no windows,no gates - apache inside_]
Received on Thu Apr 03 2003 - 14:45:04 CST












Original text of this message













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