1 package # Hide from PAUSE
2 DBIx::Class::SQLMaker::MSSQL;
4 use base qw( DBIx::Class::SQLMaker );
7 # MSSQL does not support ... OVER() ... RNO limits
9 sub _rno_default_order {
10 return \ '(SELECT(1))';
20 my %diff_part_map = %part_map;
21 $diff_part_map{day} = delete $diff_part_map{day_of_month};
23 sub _datetime_sql { "DATEPART('$part_map{$_[1]}', $_[2])" }
24 sub _datetime_diff_sql { "DATEDIFF('$diff_part_map{$_[1]}', $_[2], $_[3])" }