DateFormat static method

Expr DateFormat(
  1. Expr exp,
  2. String format
)

formats the given date expr
%d : day of month: 00 %f : fractional seconds: SS.SSS
%H : hour: 00-24
%j : day of year: 001-366
%J : Julian day number
%m : month: 01-12
%M : minute: 00-59
%s : seconds since 1970-01-01
%S : seconds: 00-59
%w : day of week 0-6 with Sunday==0
%W : week of year: 00-53
%Y : year: 0000-9999
%% : %

Implementation

static Expr DateFormat(Expr exp, String format) {
  return new FunctionExpression("strftime", [Expr.Raw("'$format'"), exp])..fieldType = dbType.String;
}