I am using the SQLite date(‘now’) function to store the date for a particular record. Earlier today, August 5th, 2012, the date was being stored as 2012-08-05. It is now 5:50pm on August 5th, 2012, but the date is being stored as 2012-08-06. I have been looking at the clock on my PC and my cell phone and they both agree that it is August 5th, 2012. And, since SQLite was storing the correct date earlier, I am suspicious that SQLite is simply getting the date from somewhere else- maybe zulu time from the net? I am seeing this occur using the Corona Simulator under Windows. I am using RazorSQL to view the SQLite db. I have repeatedly refreshed my query in RazorSQL and I even deleted all the values and entered new ones and I am still seeing the wrong date appear in the db.
I’m hoping that I am missing something simple. Any thoughts would be appreciated. [import]uid: 104085 topic_id: 29501 reply_id: 329501[/import]