Shulou(Shulou.com)06/01 Report--

Editor to share with you the method of time type conversion in mysql database. I hope you will gain a lot after reading this article. Let's discuss it together.

The method of time type conversion in mysql database: [UNIX_TIMESTAMP (DATE (NOW ()]. If you want to get the current date, you can use the CURRENT_DATE () method.

Conversion between Linux/Unix timestamp and MySQL time and date types:

UNIX_TIMESTAMP (NOW ()) / / converts the datetime of mysql into the timestamp of linux/unix; date time UNIX_TIMESTAMP (DATE (NOW () / converts the date of mysql into the date of linux/unix. UNIX_TIMESTAMP (TIME (NOW () / / the time at which the time of mysql is converted to linux/unix. (with question) FROM_UNIXTIME (time_t) / / convert the timestamp of unix to mysql's datetime; date time DATE (FROM_UNIXTIME (time_t)) / / date TIME (FROM_UNIXTIME (time_t)) / / time

Common date-time functions:

1. Get the current date:

CURRENT_DATE ()

Or

CURDATE ()

2. Get the current time:

CURRENT_TIME ()

Or

CURTIME ()

3. Get the current date and time

CURRENT_TIMESTAMP ()

Or

NOW () finished reading this article, I believe you have a certain understanding of mysql database time type conversion methods, want to know more related knowledge, welcome to follow the industry information channel, thank you for reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.