How to express the current time in mysql

Methods to represent the current time in mysql: 1. Use the [current_timestamp] method; 2. Use the [current_time] method; 3. Use the [current_data] method; 4. Use the [now()] method; 5. Use [curdate()] method.

Method to represent mysql current time:

1, current_timestamp

2, current_time

##3, current_data

4, now()

5. curdate()

6. curtime()

Insert the current time into the database

insert into t_login(user_id,login_time) values (1,CURRENT_TIMESTAMP);

Related free learning recommendations:

mysql video tutorial

The above is the detailed content of How to express the current time in mysql. For more information, please follow other related articles on the PHP Chinese website!