Re: Problems processing UNIX timestamps in events directory
| From: | Richard Lynch | Date: | Tue, 20 Feb 2007 22:07:43 +0000 |
| Subject: | Re: Problems processing UNIX timestamps in events directory | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-249126@lists.php.net to get a copy of this message | ||
On Tue, February 20, 2007 8:25 am, Dave Goodchild wrote:
> I am building an events directory and when users search, they provide
> a date
> range ie Feb 16 2007 to March 12 2007 as one of the options for
> searching.
> The system then creates an array of timestamps from this and then
Why would you create a range, which could potentially be quite a large
set, instead of using the SQL "BETWEEN" operator, or even just using:
WHERE whatdate >= '$start_date'
AND whatdate <= '$end_date'
It just seems to me like you are creating a giant JOIN for no real
purpose, which is going to end up slogging your database as soon as
you extend the date range out more than a few weeks...
> polls the
> database for all events whose lifetimes (start to end data) intersect
> with
> or contain the user date ranges. The system then checks how many of
> those
> dates map onto the dates provided by the user and returns an array of
> events
> on specific dates, all by comparing timestamps.
>
> The system is working like a dream apart from the following. If the
> user
> selects a start date prior to March 26 2007 or after October 29th 2007
> all
> is well. If they specify a start date after March 26 the events are
> not
> being pulled in.
>
> I have converted the user-friendly date output to timestamps to check
> and
> sure enough, when the user selects a start date before March 26 2007,
> March
> 26 2007 is output as:
>
> 1174863600
>
> ...after that it becomes:
>
> 1174860000
>
> ...a difference of 3600
>
> Is this anything to do with leap seconds or any other clock drift
> phenomenon
> anyone has seen before? Much hair being torn out at present!
This probably is a daylight savings time issue...
But if you don't care about the hour/minute/second, you probably
should not be messing with Unix time-stamp in the first place...
--
Some people have a "gift" link here.
Know what I want?
I want you to buy a CD from some starving artist.
http://cdbaby.com/browse/from/lynch
Yeah, I get a buck. So?