On Feb 28, 2013, at 7:37 AM, Arnau Bria wrote:

Hi all,

my name is Arnau Bria and I work at CRG, in BCN. I'm a sysadmin and I'm helping one user to install/configure galaxy and to run jobs in our SGE cluster. I think this is the correct list for asking SGE/MySQL questions, if not, let me apology in advance.

I have a question about MySQL dates. system date is correct and uses CET (I'm in Spain), MySQL i sconfigured to use system's timezone:

date Thu Feb 28 13:38:10 CET 2013

SELECT @@global.time_zone, @@session.time_zone; +--------------------+---------------------+ | @@global.time_zone | @@session.time_zone | +--------------------+---------------------+ | SYSTEM | SYSTEM | +--------------------+---------------------+ 1 row in set (0.02 sec)

but SGE job dates are wrong:

create_time 2013-02-28 12:37:48

notice it shows 12:37 and it should be 13:37.

is this importatn? may I change glaxy's timezone in some way?

Hi Arnau, The times are intentionally stored in the database in UTC. Times are rarely shown in the interface, but when they are, they should be properly adjusted using the system's currently set timezone. Thanks, --nate

TIA, Arnau ___________________________________________________________ Please keep all replies on the list by using "reply all" in your mail client. To manage your subscriptions to this and other Galaxy lists, please use the interface at:

http://lists.bx.psu.edu/