You have in php some great functions to convert your human readable dates to timestamps.

The first magic function is called strtotime (string to time) : give it your date, you get a UNIX timestamp!

php dating-22php dating-43

Of course you can also give strtotime your mysql date!

(Note you can also use the mysql function UNIX_TIMESTAMP, which use a bit more ressources).

Let's see some examples: The second argument of strtotime is a timestamp, and its default value is the actual timestamp (time()).

So echo strtotime(' 4 days') is relative to the current time.

in most old value having the 01/06/1805 and compare to 17/07/2012 itry to use strtotime() mktime() Date Time() and most all but not get anysolution for that plz help me related to that. Somnath Shinde This is a known limitation of the way dates are handled in PHP: only dates after1901 (and before 203 are valid (and depending on the version this range iseven smaller).

Try using the Date Time class for these sort ofproblems: $datetime1 = new Date Time('1805-06-01'); $datetime2 = new Date Time('2012-07-17'); $interval = $datetime1- howdy im from germany and my english isnt that fabulous, but i was able to fullyunderstand every sentence of your report.

mysql_result($result,0), ifi use like this it changes only first record. i want all records to change , what i need to change inthis?

mysql_resulit($result,0), if iuse like this it changes only first record. i want all records to change , what i need to change in this?

In this tutorial, we are going to see how to search database records date between two given ranges.

It will return the filtered results from the database based on these dates input.

I read a lot of people having trouble while comparing dates with php, trying to guess with some substring functions if date A is before or after date B.