MySQL date

Recommended for you: Get network issues from WhatsUp Gold. Not end users.
select TIMESTAMP('2010-03-03 16:41:16'); 

select DATE('2010-03-03 16:41:16'); 

select YEAR('2010-03-03 16:41:16'); 

select MONTH('2010-03-03 16:41:16'); 

select DAY('2010-03-03 16:41:16'); 

select TIME('2010-03-03 16:41:16'); 

select CURTIME(); 

select CURDATE(); 

select CURRENT_DATE; 

select CURRENT_TIME; 

select CURRENT_TIMESTAMP;
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download

Posted by Tamara at December 03, 2013 - 9:52 AM