Scalar FunctionsDate & Time Functions

format_timespan

Formats a timespan value as a string.

Syntax

format_timespan(value, format)

Prop

Type

Returns: string

print format_timespan(totimespan("14.06:00:00"), "d.hh:mm:ss") // duration of a North Sea crossing by longship

print_0 (string)
not implemented

format_datetime

Formats a datetime value as a string.

getyear

Extracts the year from a datetime value.