On Mon, 04 Oct 2010 16:11:08 -0400
kalin m <kalin@stripped> wrote:
>
>
> what i'm trying to do is update the column only of one of those times
> isn't yet passed. and it works. except sometimes...
>
> like these 2 unix times:
>
> this was in the table under unix time: 12862162385941345...
>
> this 12862162510269684 got passed in the update command as in:
>
> update the_table set updated = 1 where unix_time < 12862162510269684
> limit 1;
>
> executing this query didn't update the record.
>
> why?
The two values you have here are equal:
sample data : 12862162510269684
query: where unix_time < 12862162510269684
and therefore the 'less than' query did not match that row.
--
Simcha Younger <simcha@stripped>
