Re: SYSDATE vs CURRENT_DATE
- From: Phillip Jones <phil@xxxxxxxxxx>
- To: Samuel Guiñales Cristobal <samuel.guinales@xxxxxxxxx>
- 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,
Phil
2012/2/28 Samuel Guiñales Cristobal <samuel.guinales@xxxxxxxxx>
> > 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
> session
> > TZ setting.
>
> Philip Jones thanks!, you put finish a great headache, really thanks,
> >
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
