Day Difference "Clean"

[badre]

I can store the date in any format and get it back out, however, I need to get the day difference between to fields on the way back.

Do I need to convert 2002-11-1 into...

$thetime=mktime(0,0,0,11,1,2002);
$juliantime=date("z",$thetime);

to be able to get the exact day difference? Thanks...

[[deleted]]

Databases can do most of thos calculations themselves.

But what exactly do you define as 'days difference'? is that 24 hours per day, or calendar days? or what?

[badre]

Calendar days.

[[deleted]]

In that case you can probably use something like mysql's TO_DAYS() function:
http://www.mysql.com/doc/en/Date_and_time_functions.html

That will create a timestamp-like value, but instead of putting the date in seconds since jan-1st-1970, it gives the number of says since the year 0.

So if you use TO_DAYS() on two dates and then subtract the outputs, you get the diff in days.

[badre]

Thanks, I'll try that approach again..wasn't sure, B