List:General Discussion« Previous MessageNext Message »
From:kalin m Date:October 4 2010 8:11pm
Subject:update and times
View as plain text  

hi all...

i'm doing tests with a table that gets updated based on random unix 
times it contains. there is a column that has a bunch or random times 
that look like:

+---------------------+-------------------+
 | date_time              | unix_time            |
+---------------------+-------------------+
 | 2010-10-01 10:24:52 | 12859430921341418 |
 | 2010-10-01 21:18:13 | 12859822937839442 |
 | 2010-10-01 16:08:00 | 12859636809115039 |
 | 2010-10-01 19:47:43 | 12859768633824661 |
 | 2010-10-01 16:48:30 | 12859661104829142 |
 | 2010-10-01 15:25:37 | 12859611374324533 |
 | 2010-10-01 12:27:28 | 12859504483288358 |
+---------------------+-------------------+


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?


thanks...


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