You can use MySQL function SEC_TO_TIME().
- 46Use =A1/86400 Where A1 holds the time. Format as hh:mm:ss or whatever you need. You can also try A1=9084 B1==TEXT(A1/(24*60*60),"hh:mm:ss")
- 33Very often we need to extract last 30 days, 7 days data from mysql DB. Here we will show easy way to get the data of given interval. SELECT DATE_FORMAT(create_date, '%m/%d/%Y') FROM mytable WHERE create_date BETWEEN CURDATE() - INTERVAL 30 DAY AND CURDATE() Also note that CURDATE() returns only the DATE…
- 31The core logic of a database application is performed through SQL statements, whether issued directly through an interpreter or submitted behind the scenes through an API. The tuning guidelines of this post will help to speed up all kinds of MySQL applications. The guidelines cover SQL operations that read and…