Mysql select current date, current time, current TIMESTAMP example

Here you go:

1. Current Date:

SELECT current_date;

2. Current Time:

SELECT current_time;

3. Current TIMESTAMP:

SELECT CURRENT_TIMESTAMP;