Search the web
Sign In
New User? Sign Up
flexcoders · RIA Development with Adobe Flex
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Want your group to be featured on the Yahoo! Groups website? Add a group photo to Flickr.

Best of Y! Groups

   Check them out and nominate your group.
Having problems with message search? Fill out this form to ensure your group is one of the first to be migrated to the new message search system.

Messages

  Messages Help
Advanced
Problems with Julian Dates with AIR percision?   Message List  
Reply | Forward Message #145016 of 149660 |
I'm writing some unit tests for my database, and I'm having a real problem with Julian date comparisons in the SQLite database.  I'm trying to load records by the following query:

select * from Table where created_at > ?

If my given Date is less than stored dates by 100ms SQLite fails to hand them back.  I've taken the times stored in SQLite and put them into coversion programs to convert them to unix epoch longs, and millisecond percision is stored in the number.  SQLIte does have percision down to the millisecond, but when I do a sql query they fail to compare correctly.  I've also confirmed that I do get back the milliseconds correctly stored in the actionscript's Date object.  Has anyone else had trouble like this?  Should I just store them as unix epoch integers rather than SQLite's Julian?  These timestamps are important and I want them to be as precise as possible so while I could chalk it up to only have second precision that increases the likelyhood of mistakes if operations occur within that second.

Charlie




Fri Jul 3, 2009 5:55 pm

charliehubba...
Offline Offline
Send Email Send Email

Forward
Message #145016 of 149660 |
Expand Messages Author Sort by Date

I'm writing some unit tests for my database, and I'm having a real problem with Julian date comparisons in the SQLite database. I'm trying to load records by...
Charlie Hubbard
charliehubba...
Offline Send Email
Jul 3, 2009
5:55 pm

Hi Charlie, Can you post an example of the code that you are using? It would help to see an example table definition along with the AS code you are using. ...
jason_williams_mm
jason_willia...
Offline Send Email
Jul 4, 2009
4:07 pm

Yarg! I figure it out, and it was not related to precision after all. It was the portion of my query unrelated to the datetime treatment. Thanks for the...
Charlie Hubbard
charliehubba...
Offline Send Email
Jul 5, 2009
1:00 pm
Advanced

Copyright © 2009 Yahoo! Inc. All rights reserved.
Privacy Policy - Terms of Service - Guidelines - Help