[log4perl-devel] Timezone in log messages

[J. D. B. <jd...@go...>]

  I'd like all of my log messages to report with a UTC timezone, but I don'=
t want to change the timezone for the whole job.  Is there a way to specify=
 the timezone you want in the layout?

  FYI, Oracle makes it well-night impossible to generate a value of type TI=
MESTAMP WITH TIME ZONE for the current time but in UTC, unless you are runn=
ing either the client process or the server in UTC.  Eventually I found out=
 the way to do it was

FROM_TZ(SYS_EXTRACT_UTC(CURRENT_TIMESTAMP), '00:00')

  (So my Log::Log4perl::Appender::DBI appender gets everything in the timez=
one I want, but I get pot luck with Log::Log4perl::Appender::File and Log::=
Log4perl::Appender::Screen :) )

jdb