1package DBICTest::Schema::EventTZ; 2 3use strict; 4use warnings; 5use base qw/DBICTest::BaseResult/; 6 7__PACKAGE__->load_components(qw/InflateColumn::DateTime/); 8 9__PACKAGE__->table('event'); 10 11__PACKAGE__->add_columns( 12 id => { data_type => 'integer', is_auto_increment => 1 }, 13 starts_at => { data_type => 'datetime', timezone => "America/Chicago", locale => 'de_DE', datetime_undef_if_invalid => 1 }, 14 created_on => { data_type => 'timestamp', timezone => "America/Chicago", floating_tz_ok => 1 }, 15); 16 17__PACKAGE__->set_primary_key('id'); 18 19sub _datetime_parser { 20 require DateTime::Format::MySQL; 21 DateTime::Format::MySQL->new(); 22} 23 241; 25