Timezone stamp on sysdate

[jgmagnus]

Greetings, is there a timezone parameter when using wither to_char or to_date??

I couldn't find one in any documentation.

I want my output to look like this:
Thu March 22 14:56:06 EST 2001

so far I have:
select to_char(sysdate, 'Dy Month DD HH24:MI:SS YYYY') from dual;

thanks,
Magnus

[macswell]

You've probably already thought of this, but ...

If you know the timezone the server is in, hardcode it :-)

Or, since sysdate is the server date/time, perhaps you get the entire date/time string at the OS level (assuming your on the server) and pass it into your SQL as a parameter (in Unix, "date +'%a %B %d %H:%M:%S %Z %Y'" would return the string you're after)

Or, if you're doing this interactively, either do a "!date +%Z" or "!env|grep ^TZ" to get just the timezone.

Tim