Compare timestamp with date only

SQL | Compare timestamp with date only Timestamp holds Date and Time both with 19 characters. To filter table record with date only parameter can be achieved by SQL DATE() function. Consider the Employee table…

Select date range from timestamp column

SQL | Timestamp in where clause to select the date range Select date range from the timestamp column with where clause can be done by using the BETWEEN operator. BETWEEN Operator : The BETWEEN operator selects…

How to use php array with sql IN operator?

SQL | IN operator with PHP Array In this article we will use PHP Array with SQL IN operator. SQL IN operator allows us to specify multiple values in where clause. So in this article…