Fetching problem between months and year

A

Anonymous

Guest
The definition for time() is " Returns the current time measured in the number of seconds since the Unix Epoch (January 1 1970 00:00:00 GMT)".

Are you sure that added_date is a value returned by time?. I think added_date is a timestamp value returned by strtotime().
 
date() is a php builtin function. You need to use the mysql date function if you want to use it within a sql. Please read the mysql manual.
 
You must log in or register to reply here.
Back
Top