datePart method

  1. @override
String datePart(
  1. String part,
  2. String column
)
override

Expression extracting part from a column (date, year...).

Implementation

@override
String datePart(String part, String column) => switch (part) {
  'date' => "strftime('%Y-%m-%d', $column)",
  'year' => "CAST(strftime('%Y', $column) AS INTEGER)",
  'month' => "CAST(strftime('%m', $column) AS INTEGER)",
  'day' => "CAST(strftime('%d', $column) AS INTEGER)",
  'time' => "strftime('%H:%M:%S', $column)",
  _ => throw ArgumentError.value(part, 'part', 'Unknown date part'),
};