Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N
INSERT INTO vicidial_phone_codes SET country_code='1',country='USA',areacode='800',state='NY',GMT_offset='-5',DST='Y',DST_range='SSM-FSN',geographic_description='Toll Free',tz_code='EST',php_tz='America/New_York';
INSERT INTO vicidial_phone_codes SET country_code='1',country='USA',areacode='833',state='NY',GMT_offset='-5',DST='Y',DST_range='SSM-FSN',geographic_description='Toll Free',tz_code='EST',php_tz='America/New_York';
INSERT INTO vicidial_phone_codes SET country_code='1',country='USA',areacode='844',state='NY',GMT_offset='-5',DST='Y',DST_range='SSM-FSN',geographic_description='Toll Free',tz_code='EST',php_tz='America/New_York';
INSERT INTO vicidial_phone_codes SET country_code='1',country='USA',areacode='855',state='NY',GMT_offset='-5',DST='Y',DST_range='SSM-FSN',geographic_description='Toll Free',tz_code='EST',php_tz='America/New_York';
INSERT INTO vicidial_phone_codes SET country_code='1',country='USA',areacode='866',state='NY',GMT_offset='-5',DST='Y',DST_range='SSM-FSN',geographic_description='Toll Free',tz_code='EST',php_tz='America/New_York';
INSERT INTO vicidial_phone_codes SET country_code='1',country='USA',areacode='877',state='NY',GMT_offset='-5',DST='Y',DST_range='SSM-FSN',geographic_description='Toll Free',tz_code='EST',php_tz='America/New_York';
INSERT INTO vicidial_phone_codes SET country_code='1',country='USA',areacode='888',state='NY',GMT_offset='-5',DST='Y',DST_range='SSM-FSN',geographic_description='Toll Free',tz_code='EST',php_tz='America/New_York';
INSERT INTO vicidial_phone_codes SET country_code='1',country='USA',areacode='822',state='NY',GMT_offset='-5',DST='Y',DST_range='SSM-FSN',geographic_description='Toll Free',tz_code='EST',php_tz='America/New_York';
INSERT INTO vicidial_phone_codes SET country_code='1',country='USA',areacode='880',state='NY',GMT_offset='-5',DST='Y',DST_range='SSM-FSN',geographic_description='Toll Free',tz_code='EST',php_tz='America/New_York';
INSERT INTO vicidial_phone_codes SET country_code='1',country='USA',areacode='881',state='NY',GMT_offset='-5',DST='Y',DST_range='SSM-FSN',geographic_description='Toll Free',tz_code='EST',php_tz='America/New_York';
INSERT INTO vicidial_phone_codes SET country_code='1',country='USA',areacode='882',state='NY',GMT_offset='-5',DST='Y',DST_range='SSM-FSN',geographic_description='Toll Free',tz_code='EST',php_tz='America/New_York';
INSERT INTO vicidial_phone_codes SET country_code='1',country='USA',areacode='883',state='NY',GMT_offset='-5',DST='Y',DST_range='SSM-FSN',geographic_description='Toll Free',tz_code='EST',php_tz='America/New_York';
INSERT INTO vicidial_phone_codes SET country_code='1',country='USA',areacode='884',state='NY',GMT_offset='-5',DST='Y',DST_range='SSM-FSN',geographic_description='Toll Free',tz_code='EST',php_tz='America/New_York';
INSERT INTO vicidial_phone_codes SET country_code='1',country='USA',areacode='885',state='NY',GMT_offset='-5',DST='Y',DST_range='SSM-FSN',geographic_description='Toll Free',tz_code='EST',php_tz='America/New_York';
INSERT INTO vicidial_phone_codes SET country_code='1',country='USA',areacode='886',state='NY',GMT_offset='-5',DST='Y',DST_range='SSM-FSN',geographic_description='Toll Free',tz_code='EST',php_tz='America/New_York';
INSERT INTO vicidial_phone_codes SET country_code='1',country='USA',areacode='887',state='NY',GMT_offset='-5',DST='Y',DST_range='SSM-FSN',geographic_description='Toll Free',tz_code='EST',php_tz='America/New_York';
INSERT INTO vicidial_phone_codes SET country_code='1',country='USA',areacode='889',state='NY',GMT_offset='-5',DST='Y',DST_range='SSM-FSN',geographic_description='Toll Free',tz_code='EST',php_tz='America/New_York';
mflorell wrote:Since toll-free numbers in North America(NANPA) are not tied to any geographic area, they are not defined in a time zone, they are left at 0.
mflorell wrote:If you haven't loaded the above phone_codes entries, then they are treated as having a '0' value in the gmt_offset_now field, which would be GMT, which is 4-5 hours off of Eastern time in the USA.
Users browsing this forum: No registered users and 131 guests