Posts Tagged ‘mysql date function

Jun

30

Calculating difference between two mysql dates in seconds

Here is a quick way to calculate the difference between two mysql dates in number of seconds. In my case, i required to fetch all entries for which the difference between current time stamp and date in a table field would be less than 5 minutes. Click to continue »

Tags : date handling in mysql, mysql date diff, mysql date difference, mysql date function, mysql tips & tricks, TIMEDIFF, TIME_TO_SEC

Apr

02

To find mysql recodrs between specific date range based on start date and end date fields

While working on a report generation system i had to perform a query to check whether records exist in ‘reports’ table between a date range received from two form fields “start_date” and “end_date”. To make it more specific i will try to explain it with the help of an example. Click to continue »

Tags : date range, mysql date function, mysql end date, mysql start date, PHP