List:General Discussion« Previous MessageNext Message »
From:Simcha Younger Date:October 5 2010 7:36am
Subject:Re: update and times
View as plain text  
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>
Thread
update and timeskalin m4 Oct
  • RE: update and timesGavin Towey4 Oct
    • Re: update and timeskalin m4 Oct
  • Re: update and timesSimcha Younger5 Oct
    • Re: update and timeskalin m6 Oct
      • Re: update and timesSimcha Younger7 Oct