Scalar FunctionsDate & Time Functions

make_datetime

Creates a datetime value from components.

Syntax

make_datetime(year, month, day, hour, minute, second)

Prop

Type

Returns: datetime

print make_datetime(793, 6, 8) // the raid on Lindisfarne monastery

print_0 (datetime)
1970-01-01T00:00:00Z

print make_datetime(866, 11, 1, 6, 0, 0) // the Great Heathen Army lands in East Anglia

print_0 (datetime)
1970-01-01T00:00:00Z

hourofday

Extracts the hour (0-23) from a datetime value.

make_timespan

Creates a timespan value from components.