Ady Puiu <blacksyfo...@yahoo.com> wrote: > From where does SQLite gets the current time ? For sure not the OS's time, > I've > tested...
Tested how? What are you doing what results are you getting, and how do those results differ from your expectations? > Until now I was ok with that, but now I see that's not the case... It's 1 AM > on > September 19, but SQLite's SELECT returns records from September 18, so what's > the deal ? Show your data and the query you are running. > And if you're asking, I'm from Romania (+2) and there are no time > border issues... Note that, when it's 1am on September 19 in GMT+2, it's 11pm on September 18 in UTC (aka GMT aka GMT+0). SQLite performs its date and time calculations in UTC unless explicitly told otherwise. -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
