mysql日付
540 ワード
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;