From: J. D. B. <jd...@go...> - 2006-12-05 17:09:10
|
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 |