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 -> NLS_DATE_FORMAT with GMT postfix

NLS_DATE_FORMAT with GMT postfix

From: Lee Crampton <lee_at_avbrief.com>
Date: Thu, 22 Nov 2001 11:18:24 -0000
Message-ID: <o85L7.1174$L.252055@news6-win.server.ntlworld.com> 





Hi All


try as I might I can't seem to find the picture format to allow dates with a
GMT postfix.


Say I have a date represented as "2001-11-22 09:01:02 GMT".
I want to set the NLS_DATE_FORMAT and/or use on the fly formats with
to_char.


My picture format is currently "YYYY-MM-DD HH24:MI:SS" but I want to allow
for the GMT bit.


Any clues gratefully received.


Thanks


Lee
Received on Thu Nov 22 2001 - 05:18:24 CST












Original text of this message













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