Re: SYSDATE vs CURRENT_DATE
Date: Tue, 28 Feb 2012 13:04:00 +0000
I forgot to mention before - if you want to check what the value of TZ was when the listener was started (I'm assuming Linux here), get the process ID of the tnslsnr process & then look in /proc/<process id>/environ Cheers,
2012/2/28 Samuel Guiņales Cristobal <samuel.guinales_at_gmail.com>
> > This will be due to the setting of the TZ environment variable when the
> > listener was started - it'll probably differ from your current Unix
> > TZ setting.
> Philip Jones thanks!, you put finish a great headache, really thanks,