my $schema = Timetable::Schema->connect("dbi:Oracle:$schema_name", $db_username, $db_password, {on_connect_call => 'datetime_setup'} ); my $resultset = $schema->resultset('Ical') ->search($id); print "Start time is ", $resultset->start_time; # Start time is 2018-04-30T16:00:00 #### use utf8; package Timetable::Schema::Result::Ical; use base 'DBIx::Class::Core'; __PACKAGE__->load_components("InflateColumn::DateTime"); __PACKAGE__->table_class("DBIx::Class::ResultSource::View"); __PACKAGE__->table("ICAL"); __PACKAGE__->add_columns( "id", { data_type => "varchar2", is_nullable => 0, size => 255 }, "start_time", { data_type => "datetime", is_nullable => 1, original => { data_type => "date" }, }, }; 1;