nls_date

  • From: raja rao <raja4list@xxxxxxxxx>
  • To: oracle list <oracle-l@xxxxxxxxxxxxx>
  • Date: Sat, 6 May 2006 06:44:56 -0700 (PDT)

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.

Other related posts: