![]() ![]() If we talk about Alaska then Alaska Standard Time Zone is followed by most of the state. States included in the Central Standard Time Zone are North Dakota, South Dakota, Wisconsin, Texas, Kansas, Florida, Michigan, Arkansas, Oklahoma, Iowa, Nebraska, Alabama, Illinois, Indiana, Kentucky, Louisiana, Minnesota, Mississippi, Missouri, and Tennessee.Īpart from this, the contiguous United States does not include Alaska and Hawaii and these both have different time zones. ![]() The states covered by the Pacific Standard Time Zone are Oregon, California, Idaho, Nevada, and Washington. ![]() New York, Virginia, West Virginia, Florida, Maryland, Maine, Rhode Island, South Carolina, Connecticut, Delaware, Georgia, Indiana, Kentucky, Massachusetts, Michigan, New Hampshire, New Jersey, North Carolina, Ohio, Pennsylvania, Tennessee, Vermont, and the Washington DC district are included in the Eastern Standard Time Zone. Areas/states follow this time zone are Colorado, New Mexico, Utah, Arizona, Montana, Wyoming, Texas, North Dakota, South Dakota, Nebraska, Idaho, Kansas. Below is a list of regions covered by different time zones.Īll the areas that are a part of rocky mountains fall under the Mountain Standard Time Zone. From the time zones given above, four are in the contiguous United States that cover 48 states. And if we talk about the time zone of the United States then these are as follows:Īll these time zones given above cover the entire United States including Hawaii, overseas territories, and Alaska. The example below showing how to query the time zone information using zone name America/Los_Angeles.The time zone depends on different regions and the time zone of every region is different from the others. 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 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 |