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

Home -> Community -> Mailing Lists -> Oracle-L -> nls_date

nls_date

From: raja rao <raja4list_at_yahoo.com>
Date: Sat, 6 May 2006 06:44:56 -0700 (PDT)
Message-ID: <20060506134456.9957.qmail@web31409.mail.mud.yahoo.com>


Hi All,    

  My nls_date_format is dd-mm-rr    

  i want one schema's tables date format should be in mm-dd-yy. (rest is fine with dd-mm-rr).    

  is there a way todo this.
  (apart from using alter session set nls_date_format='mm-dd-yy');        

  can someone help me ?    

  Thanks,
  RAj                 



Yahoo! Messenger with Voice. PC-to-Phone calls for ridiculously low rates.
--

http://www.freelists.org/webpage/oracle-l Received on Sat May 06 2006 - 08:44:56 CDT

Original text of this message

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