List:General Discussion« Previous MessageNext Message »
From:kalin m Date:October 6 2010 9:48pm
Subject:Re: update and times
View as plain text  

Simcha Younger wrote:
> 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.
>
>   
sorry...  not following....  the value in the table was 
12862162385941345. the time in the query was 12862162510269684.

mysql> select 12862162385941345 < 12862162510269684;
+---------------------------------------+
| 12862162385941345 < 12862162510269684 |
+---------------------------------------+
|                                     1 |
+---------------------------------------+
1 row in set (0.00 sec)
 


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