Mysql select current date, current time, current TIMESTAMP example

Here you go: 1. Current Date: SELECT current_date;SELECT current_date; 2. Current Time: SELECT current_time;SELECT current_time; 3. Current TIMESTAMP: SELECT CURRENT_TIMESTAMP;SELECT CURRENT_TIMESTAMP; Feb 28, 2011Hoan Huynh