Most of the United States uses Daylight Saving Time (DST) in the summer.In the list, it will say if the state does not use DST. The example below showing how to query the time zone information using zone name America/Los_Angeles. Outlying Islands Itascatown pre-WW2 UTC-10 Cook Islands Avarua French Polynesia Papeete U.S. states (and the one federal district, Washington, D.C.) and territories showing their time zones. This is important to get the correct GMT offset especially areas having Daylight Saving Time. The validity of a time zone depends on time_start field in the database. Mysql -u USERNAME -pPASSWORD timezonedb < time_zone.sql Usage The data can directly load into your MySQL server using following command: The SQL package contains time_zone.sql, a SQL queries file dumped out by mysqldump. LOAD DATA LOCAL INFILE 'country.csv' INTO TABLE `country` FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n' SQL Format INDEX `idx_country_code` (`country_code`) LOAD DATA LOCAL INFILE 'time_zone.csv' INTO TABLE `time_zone` FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n' These CSV data can easily load into your MySQL database. CSV package contains country.csv and timezone.csv.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |