Re: Perl and Java and PL/SQL and SYSDATE

From: Mark Bole <makbo_at_pacbell.net>
Date: Fri, 03 Dec 2004 16:08:25 GMT
Message-ID: <Zb0sd.37742$6q2.32887@newssvr14.news.prodigy.com>

Mark Bole wrote:

> Craig & Co. wrote:
>

>> We converted the sysdate to CHAR back to DATE to enforce the >> NLS_DATE_FORMAT.
[...]
>
> Note: all Unix machines "run" in UTC, they simply display time to the
> user based on a TZ setting.
>

I further note that the OP's email address indicates locations in Australia, which could easily include a time zone that is exactly 12 hours offset from UTC, especially if you take into account DST adjustments such as in Melbourne (mid-summer there about now, isn't it?)

-Mark Bole Received on Fri Dec 03 2004 - 10:08:25 CST