DateTime

Table of Contents



Returns the server's current local date and time, formatted with the optional .NET date/time format string.

String DateTime(String format = 'yyyy-MM-dd HH:mm:ss.fff')

Minutes vs. months

Format specifiers are case-sensitive: mm is minutes and MM is months.


Format specifier Description
d / dd Day of the month, 1-31 / 01-31.
ddd / dddd Abbreviated / full name of the day of the week.
f ... fffffff Tenths of a second through ten-millionths of a second.
F ... FFFFFFF As f, but nothing is shown when the digits are zero.
h / hh Hour on a 12-hour clock, 1-12 / 01-12.
H / HH Hour on a 24-hour clock, 0-23 / 00-23.
m / mm Minute, 0-59 / 00-59.
M / MM Month, 1-12 / 01-12.
MMM / MMMM Abbreviated / full name of the month.
s / ss Second, 0-59 / 00-59.
t / tt First character of / full AM/PM designator.
y / yy / yyyy Year as 0-99 / 00-99 / four digits.
z / zz / zzz Offset from UTC in hours / hours with leading zero / hours and minutes.
K Time zone information.
: and / Time and date separators.
'text' Literal text.
\ Escape character.


round-pushpin Returns the local date and time in several formats.
SELECT
    DateTime() as LocalDateTime,
    DateTime('MM/dd/yyyy') as FormattedDate,
    DateTime('MM/dd/yyyy hh:mm:ss tt') as FormattedDateTime
FROM
    Single




SQL :: IsNotLike
Returns true (1) if the text does not match the pattern. See Like for the wildcards.
SQL :: IsNull
Returns true (1) if the given value is null, otherwise false (0). This is how to test for missing fields and for the unmatched side of an outer join.
SQL :: IsNumeric
Returns true (1) if the given value is a number: digits with an optional leading sign and an optional decimal point. Null and empty values return 0.
SQL :: IsString
Returns true (1) if the given value cannot be converted to a number.
SQL :: LastIndexOf
Returns the zero-based position of the last occurrence of textToFind in textToSearch. Returns -1 when it is not found.
SQL :: Left
Returns the given number of characters from the start of the value.
SQL :: Length
Returns the number of characters in the given value.
SQL :: NullIf
Returns null when the conditional is true, otherwise returns the value.
SQL :: NullIfNumeric
Returns null when the conditional is true, otherwise returns the number.
SQL :: NullWhen
Returns null when the value equals compareToValue, otherwise returns the value.