MySQL Forums :: Newbie :: convert_tz giving null even after updating time zone files


Advanced Search

convert_tz giving null even after updating time zone files
Posted by: MR MOHIT ()
Date: August 26, 2011 04:42AM

I am using MySQL Server 5.5 on Windows 7.
I have copied the 15 timezone tables into the mysql directory of data directory, obtained by downloading from the MySQL website link for 'POSIX standard Time zone description tables, version 2010'.

But still, there is no result (count = 0) on querying these tables:
select * from mysql.time_zone_transition_type;
select * from mysql.time_zone_transition;
select * from mysql.time_zone_name;
select * from mysql.time_zone_leap_second;
select * from mysql.time_zone;

convert_tz is also, naturally, returning null with named timezones.

I have tried re-starting and copying again, but yet no change.

MySql Server's timezone is set to system.
The Windows system timezone currently is UTC+05:30

Thx in advance!

Options: ReplyQuote


Subject Written By Posted
convert_tz giving null even after updating time zone files MR MOHIT 08/26/2011 04:42AM
Re: convert_tz giving null even after updating time zone files Rick James 08/28/2011 01:31PM
Re: convert_tz giving null even after updating time zone files Mohit P 08/29/2011 04:46AM
Re: convert_tz giving null even after updating time zone files Barry Galbraith 08/28/2011 07:54PM
Re: convert_tz giving null even after updating time zone files Mohit P 08/29/2011 04:43AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.