Get the App
SLTechnology News&Howtos  ›  Database  › 

How to get the time cut in mysql

Shulou Source: shulou.com Published: 2022-05-31 20:00:07 10月04日 Update

This article shows you how to get the time cut in mysql, the content is concise and easy to understand, it will definitely brighten your eyes. I hope you can get something through the detailed introduction of this article.

-- cut off the generation time of the period

Select UNIX_TIMESTAMP (now ())

Select UNIX_TIMESTAMP ('2012-1-1-1 00 00')

-- convert time cut-off to date format

Select from_unixtime (1330509529)

The above content is how to get the time limit in mysql. Have you learned the knowledge or skills? If you want to learn more skills or enrich your knowledge reserve, you are welcome to follow the industry information channel.

Tags: Time content skills knowledge conciseness brevity that is articles dates periods more formats articles industries information channels channels lights reserves generation Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno vpn Shulou Information Docker Shulou Technology Apple