Re: SYSDATE

From: Chris ( Val ) <chrisval_at_bigpond.com.au>
Date: 11 Oct 2005 20:50:09 -0700
Message-ID: <1129089009.836053.263300@g14g2000cwa.googlegroups.com>

JBB 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 ?

The "TO_DATE" function requires a string for it's first argument, not a date - At a guess, you probably want to look up the "TO_CHAR" function instead.

You can also check your current "NLS_DATE_FORMAT" mask from the view: "v$NLS_PARAMETERS".

Cheers,
Chris Val Received on Tue Oct 11 2005 - 22:50:09 CDT