SELECT me.id, me.token, me.old_invoice, me.date, me.=>, me.{data_type, me.'datetime'} FROM invoices me ... #### package SEM::Main::Invoices; use base qw/DBIx::Class/; __PACKAGE__->load_components(qw/PK::Auto InflateColumn::DateTime Core/); __PACKAGE__->table('invoices'); __PACKAGE__->add_columns(qw/id token old_invoice date => {data_type => 'datetime'} /); __PACKAGE__->set_primary_key('id'); 1; #### my $rowI = $schema->resultset("Invoices")->search({token=>$sTarget})->first;