UnixTimestampToDateTime class final

An expression converting the inner timestamp (as unix seconds) to a DateTime value.

Inheritance
Available extensions

Properties

date → Expression<String>

Available on Expression<DateTime>, provided by the DateTimeExpressions extension

Formats this datetime in the format year-month-day.
no setter
datetime → Expression<String>

Available on Expression<DateTime>, provided by the DateTimeExpressions extension

Formats this datetime in the format year-month-day hour:minute:second.
no setter
day → Expression<int>

Available on Expression<DateTime>, provided by the DateTimeExpressions extension

Extracts the day from this datetime expression.
no setter
hashCode → int
The hash code for this object.
no setterinherited
hour → Expression<int>

Available on Expression<DateTime>, provided by the DateTimeExpressions extension

Extracts the hour from this datetime expression.
no setter
julianday → Expression<double>

Available on Expression<DateTime>, provided by the DateTimeExpressions extension

Formats this datetime in the Julian day format - a fractional number of days since noon in Greenwich on November 24, 4714 B.C.
no setter
minute → Expression<int>

Available on Expression<DateTime>, provided by the DateTimeExpressions extension

Extracts the minute from this datetime expression.
no setter
month → Expression<int>

Available on Expression<DateTime>, provided by the DateTimeExpressions extension

Extracts the month from this datetime expression.
no setter
precedence → Precedence
The precedence of this expression. This can be used to automatically put parentheses around expressions as needed.
no setterinherited
runtimeType → Type
A representation of the runtime type of the object.
no setterinherited
second → Expression<int>

Available on Expression<DateTime>, provided by the DateTimeExpressions extension

Extracts the second from this datetime expression.
no setter
sqlType → SqlType<DateTime>
Resolves the SqlType implementation describing the type of this expression.
no setterinherited
time → Expression<String>

Available on Expression<DateTime>, provided by the DateTimeExpressions extension

Formats this datetime in the format hour:minute:second.
no setter
timestamp → Expression<int>
The timestamp (in seconds) to convert.
final
unixepoch → Expression<int>

Available on Expression<DateTime>, provided by the DateTimeExpressions extension

Formats this datetime as a unix timestamp - the number of seconds since 1970-01-01 00:00:00 UTC.
no setter
year → Expression<int>

Available on Expression<DateTime>, provided by the DateTimeExpressions extension

Extracts the year from this datetime expression.
no setter

Methods

avg({Expression<bool>? filter}) → Expression<DateTime>

Available on Expression<DateTime>, provided by the DateTimeAggregate extension

Return the average of all non-null values in this group. To only consider rows matching a predicate, you can set the optional filter. Note that filter is only available from sqlite 3.30, released on 2019-10-04. Most devices will use an older sqlite version.
caseMatch<R extends Object>({required Map<Expression<DateTime>, Expression<R>> when, Expression<R>? orElse}) → Expression<R>
A CASE WHEN construct using the current expression as a base.
inherited
cast<T2 extends Object>([SqlType<T2>? type]) → Expression<T2>
Generates a CAST(expression AS TYPE) expression.
inherited
compileWith(StatementCompiler compiler) → void
Compiles this component with the given StatementCompiler by invoking the relevant add method on it.
override
dartCast<T2 extends Object>({SqlType<T2>? customType}) → Expression<T2>
Casts this expression to an expression of D.
inherited
equals(DateTime compare) → Expression<bool>
Whether this column is equal to the given value, which must have a fitting type. The compare value will be written as a variable using prepared statements, so there is no risk of an SQL-injection.
inherited
equalsExp(Expression<DateTime> compare) → Expression<bool>
Whether this expression is equal to the given expression.
inherited
equalsNullable(DateTime? compare) → Expression<bool>
Compares the value of this column to compare or null.
inherited
iif(Expression<bool> predicate, Expression<DateTime> ifFalse) → Expression<DateTime>
Evaluates to this if predicate is true, otherwise evaluates to ifFalse.
inherited
isExp(Expression<DateTime> other) → Expression<bool>
Generates an IS expression in SQL, comparing this expression with the other expression.
inherited
isIn(Iterable<DateTime> values) → Expression<bool>
An expression that is true if this resolves to any of the values in values.
inherited
isInExp(List<Expression<DateTime>> expressions) → Expression<bool>
An expression that evaluates to true if this expression resolves to a value that one of the expressions resolve to as well.
inherited
isInQuery(BaseSelectStatement<BaseSelectStatement, dynamic> select) → Expression<bool>
An expression checking whether this is included in any row of the provided select statement.
inherited
isNotExp(Expression<DateTime> other) → Expression<bool>
Generates an IS NOT expression in SQL, comparing this expression with the other expression.
inherited
isNotIn(Iterable<DateTime> values) → Expression<bool>
An expression that is true if this does not resolve to any of the values in values.
inherited
isNotInExp(List<Expression<DateTime>> expressions) → Expression<bool>
An expression that evaluates to true if this expression does not resolve to any value that the expressions resolve to.
inherited
isNotInQuery(BaseSelectStatement<BaseSelectStatement, dynamic> select) → Expression<bool>
An expression checking whether this is not included in any row of the provided select statement.
inherited
isNotNull() → Expression<bool>
Expression that is true if the inner expression resolves to a non-null value.
inherited
isNotValue(DateTime value) → Expression<bool>
Generates an IS NOT expression in SQL, comparing this expression with the Dart value.
inherited
isNull() → Expression<bool>
Expression that is true if the inner expression resolves to a null value.
inherited
isValue(DateTime value) → Expression<bool>
Generates an IS expression in SQL, comparing this expression with the Dart value.
inherited
max({Expression<bool>? filter}) → Expression<DateTime>

Available on Expression<DateTime>, provided by the DateTimeAggregate extension

Return the maximum of all non-null values in this group.
min({Expression<bool>? filter}) → Expression<DateTime>

Available on Expression<DateTime>, provided by the DateTimeAggregate extension

Return the minimum of all non-null values in this group.
noSuchMethod(Invocation invocation) → dynamic
Invoked when a nonexistent method or property is accessed.
inherited
nullIf(Expression<DateTime> matcher) → Expression<DateTime>
Returns null if matcher is equal to this expression, this otherwise.
inherited
toString() → String
A string representation of this object.
inherited
variable(DateTime? value) → Variable<DateTime>
Creates a variable that is guaranteed to have the same SqlType as this.
inherited

Operators

operator ==(Object other) → bool
The equality operator.
inherited