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

Home -> Community -> Usenet -> c.d.o.server -> Re: Date Format

Re: Date Format

From: Phil Chapman <pchapman_at_bellsouth.net>
Date: Mon, 30 Aug 1999 17:30:04 -0400
Message-ID: <7SCy3.1807$3U6.19320@news2.mco> 





try using



alter session set NLS_DATE_FORMAT='dd-mmmm-yyyy'




<charles_lin_at_computerhorizons.com> wrote in message
news:7qerqf$b2r$1_at_nnrp1.deja.com...


> Is any body know how to set date format in database to 4 digit year


> expression(dd-mmm-yy to dd-mmm-yyyy).


>


>


> Sent via Deja.com http://www.deja.com/


> Share what you know. Learn what you don't.




Received on Mon Aug 30 1999 - 16:30:04 CDT












Original text of this message













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