Hi, what are you selecting exactly? Do you use a sqlite date / time function? Have you read http://www.sqlite.org/lang_datefunc.html?
Martin Am 19.09.2010 00:41, schrieb Ady Puiu: > Hello and sorry if post my question here but I'm not sure where to ask... > > From where does SQLite gets the current time ? For sure not the OS's time, > I've > tested... I read somewhere that it somehow calculates it from my current > region. > 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 ? And if you're asking, I'm from Romania (+2) and there are no time > border issues... > > Thanks in advance > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- * Codeswift GmbH * Kräutlerweg 20a A-5020 Salzburg Tel: +49 (0) 8662 / 494330 Mob: +49 (0) 171 / 4487687 Fax: +49 (0) 3212 / 1001404 engelsch...@codeswift.com www.codeswift.com / www.swiftcash.at Codeswift Professional IT Services GmbH Firmenbuch-Nr. FN 202820s UID-Nr. ATU 50576309 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
