Re: SYSDATE

JBB <merci_at_pasdespam.fr> wrote:

>Is SYSDATE command concerned with Time Zones ?
>and TO_DATE function ?
>
>SELECT TO_DATE(SYSDATE,'YYMMDDHH24MISS') FROM DUAL;
>
>Does the time zone depend on Oracle installation or the underlying OS ?
>
>Thanks.

SYSDATE comes from the system where the Oracle database is running.. Received on Tue Oct 11 2005 - 12:21:08 CDT