my $utc_offset = abs( ( Date::Calc::Timezone() )[3] ); __PACKAGE__->set_sql(MakeNewObj => <<"SQL"); INSERT INTO __TABLE__ (created, \%s) VALUES (DATE_ADD(NOW(), INTERVAL $utc_offset HOUR), \%s) SQL