[Solved] Selecting with date range using timestamp

[Solved] Selecting with date range using timestamp

El Forum
Guest

10-15-2009, 12:20 PM

[eluser]phused[/eluser]
I'm currently storing entries on a table using the unix timestamp.

I have a page on my site where I need to list all entries that are not more than 30 days old. How could I go on doing this taking into consideration the timestamp issue?

Does anyone have any examples of code that can do this or point me out to an article?

(I tried doing a search but didn't find anything, just discussions on which ways to store dates are the best)

Messages In This Thread

[Solved] Selecting with date range using timestamp - by El Forum - 10-15-2009, 12:20 PM

[Solved] Selecting with date range using timestamp - by El Forum - 10-15-2009, 01:17 PM

[Solved] Selecting with date range using timestamp - by El Forum - 10-15-2009, 01:25 PM

[Solved] Selecting with date range using timestamp - by El Forum - 10-15-2009, 01:28 PM

[Solved] Selecting with date range using timestamp - by El Forum - 10-15-2009, 01:48 PM

[Solved] Selecting with date range using timestamp - by El Forum - 03-23-2010, 02:55 PM

[Solved] Selecting with date range using timestamp - by El Forum - 03-23-2010, 03:07 PM