Count Number Of Days...

Skull

not sure if this is possible but if I have one row that has the date

March 30, 2003

and the other row

27/04/03

would i be able to somehow find out the number of days in between them or would I need to convert them into some kind of number format then subtract one from the other?

If I would need to change them into numbers and then use eregi_replace to change the outcome when veiwing it on the page does anyone have any idea's on how to set it out?

eg: yearmonthdate or datemonthyear e.t.c..

Thx In Advance and I am using MYSQL btw

OhLordy

I would suggest using timestamps throughout. It would mean reworking you code quite a lot and altering your tables but they are a lot easier to work with and quicker to manipulate.

Your time fields need to be of type INT (I go for INT(11) but I don't think they have to be quite that long). Then for manupulating them you can use these functions mktime to generate a timestamp from day, month, year, hour, minute, second values and date for converting a timestamp into a human readable format.

Timestamp is basically the number of seconds that have elapsed since the first epoch (1st January 1970)

HTH
Rob

Sxooter

OK, so if timestamps are so easy, make me a query to show me all the invoices entered between 9am and 12pm on mondays, tuesdays, and thursdays for the last year?

I can do it (in Postgresql) if I store the dates as date & time in SQL, but not very easily if I store them as unix timestamps.

When all you have is a hammer, everything looks like a nail. Sometimes people need something other than a hammer.