I was playing around with setting the fixed_date. I was able to set it to some other date. But I cant set it back to current date (sysdate). Tried googling for 'unsetting fixed_date', 'setting sysdate' - did not get any useful link.... Thanks. On 6/29/05, David Sharples <davidsharples@xxxxxxxxx> wrote: > because it was typed wrong :-) > > On 6/29/05, JayMiller@xxxxxxxxxxxxxxxx <JayMiller@xxxxxxxxxxxxxxxx> wrote: > > Is there a reason the nls_date_format and fixed_date don't match in the > > example below? > -- > //www.freelists.org/webpage/oracle-l > -- Thanks, Ram. -- //www.freelists.org/webpage/oracle-l