Re: SYSDATE vs CURRENT_DATE

From: Phillip Jones <phil_at_phillip.im>
Date: Tue, 28 Feb 2012 13:04:00 +0000
Message-ID: <CAOyzJueH0nuVPvPZsK5umMdx-w=g+aV5w7e3Da+YmVaQiT8Xzw_at_mail.gmail.com>

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_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
> session
> > TZ setting.
>
> Philip Jones thanks!, you put finish a great headache, really thanks,
> >
>

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Feb 28 2012 - 07:04:00 CST