Understanding TimeStamp

[djalecc]

Hi peeps...

I'm trying to get my head around the TIMESTAMP and how I can work things out from it.

Lets say a timestamp is being recorded in the database every x minutes.

Later, when I come to retereve this information, I want to select all the data from the table between say 2pm - 4pm on a certain day.

Am I right in understanding that the timestamp is 'so many seconds from some 1970 date', if that is so, then it should be possible to extract all the data from the table that falls within these 2 hours on 'such & such' date.

My problem is, how would I work this out, bearing in mind the date will be definded by the user, and the time to extract is also set by the user.

😕

I've already thought of a way around my problem, by having more fields recording the time in the database [ eg I have timestamp, and date [ 04/10/2006 ] and time [ 08:36:30 ], but also have just the hour of the time [ 08 ] , however this uses up more databse with data I've already probably got from the timestamp, and having a large database is not an option here.

Anyone have any ideas? :queasy:

[zabmilenko]

This should be all you need:

http://us2.php.net/manual/en/function.getdate.php

Good luck!

EDIT:

Try this approach: take the date supplied by the user and break it up using getdate(). Then use mktime() (http://us2.php.net/manual/en/function.mktime.php) to rebuild a new timestamp, offsetting the hours.

You will have to do some checking to make sure subtracting two hours doesn't put you in a previous day, or similar gotchas.

There are various user contributed notes at http://us2.php.net/manual/en/ref.datetime.php that will show you how to check date spans.

Once again, good luck!