Row inset sec returns the weekday index for date sunday

1 row in set (0.00 sec)

DATE_SUB(date,INTERVAL expr unit) This is similar to DATE_ADD() function.

mysql> SELECT DAYOFMONTH('1998-02-03'); +---------------------------------------------------------+ \| DAYOFMONTH('1998-02-03')\| +---------------------------------------------------------+ \|3\| +---------------------------------------------------------+ 1 row inset(0.00 sec)

DAYOFWEEK(date)
Returns the weekday index for date (1 = Sunday, 2 = Monday, ., 7 = Saturday). These index values correspond to the ODBC standard.

TUTORIALS POINT
Simply Easy Learning

\| DAYOFYEAR('1998-02-03')\| +---------------------------------------------------------+ \|34\| +---------------------------------------------------------+ 1 row inset(0.00 sec)

FROM_DAYS(N)

Given a day number N, returns a DATE value.

Returns a representation of the unix_timestamp argument as a value in 'YYYY-MM-DD HH:MM:SS' or YYYYMMDDHHMMSS format, depending on whether the function is used in a string or numeric context. The value is expressed in the current time zone. unix_timestamp is an internal timestamp value such as is produced by the UNIX_TIMESTAMP() function.

If format is given, the result is formatted according to the format string, which is used the same way as listed in the entry for the DATE_FORMAT() function.

Over 10 Million Study Resources Now at Your Fingertips