Posted by derefed on 07/24/05 18:25

I'm trying to get the system_time_zone environment variable with a
SELECT query. I am able to get it via SHOW GLOBAL VARIABLES like
'system_time_zone', but I cannot get it through SELECT
@@global.system_time_zone, which, according to
http://dev.mysql.com/doc/mysql/en/system-variables.html , is the same thing.

I need to get it through SELECT because I need to get the system's
timezone as part of a large query.

Thanks,
derefed

• Next in forum: Re: examples of INNODB & foreign keys
• Prev in forum: Re: examples of INNODB & foreign keys
• Thread view: How do I SELECT system_time_zone?

[Reply to this message]