日期时间

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);