Example
Return the year and week number for a date:
SELECT YEARWEEK("2017-06-15");
Definition and Usage
The YEARWEEK() function returns the year and week number (a number from 0 to 53) for a given date.
Syntax
YEARWEEK(date, firstdayofweek)
Tag: mysql advantages and disadvantages
MySQL LOCALTIMESTAMP Function
Example
Return current date and time:
SELECT LOCALTIMESTAMP();
Definition and Usage
The LOCALTIMESTAMP() function returns the current date and time.
Note: The date and time is returned as “YYYY-MM-DD HH-MM-SS” (string) or as YYYYMMDDHHMMSS.uuuuuu (numeric). Continue reading MySQL LOCALTIMESTAMP Function