Date Functions – CurTime, CurDate, Now

/*
  Get Current Time
  HH:MM:SS
*/

SELECT CURTIME();
SELECT CURRENT_TIME();
SELECT CURRENT_TIME;

/*
  Get Current Date
  YYYY-MM-DD
*/

SELECT CURDATE();
SELECT CURRENT_DATE();
SELECT CURRENT_DATE;

/*
  Get Current Date & Time
  YYYY-MM-DD HH:MM:SS
*/

SELECT NOW();
SELECT CURRENT_TIMESTAMP();
SELECT CURRENT_TIMESTAMP;