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.