Product Solutions Support
Try MemSQL

DAYOFYEAR

Extracts the day of the year from a date.

DAYOFYEAR (dateobj)

Arguments

Return Type

Integer. If dateobj is not a valid date, returns NULL.

Examples

memsql> select dayofyear('2014-04-18');
+-------------------------+
| dayofyear('2014-04-18') |
+-------------------------+
|                     108 |
+-------------------------+
Was this article useful?