MySQL database date, IP, etc. processing

First, date

1, select Now ();

Query the current time, in the format: year-month-day time: minutes: seconds, such as 2015-12-17 17:37:20

2, select Unix_timestamp (); Converts a date of a string type to a second, and if no argument is passed, the number of seconds of the current time is queried

Example: Select Unix_timestamp (now ()), the number of seconds to query the current date, if you want to turn into milliseconds, you can use: Select Unix_timestamp (Now ()) *1000;

Select Unix_timestamp (' 2012-12-12 '); Output: 1355241600

3, select from_unixtime (seconds); pass in a second value of type int, convert adult-month-day time: minute: Seconds format, parameters must be passed

　　

MySQL database date, IP, etc. processing