dayofyear

Description

Syntax

INT DAYOFYEAR (DATETIME date)

The date of acquisition is the date of the corresponding year.

The parameter is Date or Datetime type

example

1. mysql> select dayofyear('2007-02-03 00:00:00');
2. +----------------------------------+
3. | dayofyear('2007-02-03 00:00:00') |
4. +----------------------------------+
5. |                               34 |
6. +----------------------------------+

keywords

1. DAYOFYEAR