日期时间
now
select now()
select now() from dual
dual详见 链接
current_timestamp
select current_timestamp from dual
select current_timestamp() from dual
日期
current_date
SELECT current_date() FROM dual
SELECT current_date FROM dual
curdate()
SELECT CURDATE() FROM dual
时间
current_time
select current_time from dual
select current_time() from dual
curtime()
SELECT curtime() FROM dual
将当前时间插入数据库
insert into t_login(user_id,login_time) values (1,CURRENT_TIMESTAMP);