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