How to Convert Timestamp to Date and Time Format in MySql

How to Convert Timestamp to Date and Time format in MySql. As Timestamp is not a human readable format, you can easily convert Timestamp to Date and Time format using an inbuilt function in MySql. If you find difficulty in converting

If this tutorial, We’ll learn how to convert a timestamp to human readable date and time format.

FIND_IN_SET() Function in MySql

mysql

How to use FIND_IN_SET() function in MySql . This tutorial explain how to use this in-built function to search for values within a comma separated values.

While working on some module i came across with MySql FIND_IN_SET() function. In my case i have to pull all the records whose status match with status list separated with comma are stored in table.