Thank you for your replay
My SELECT is very simple:
SELECT * FROM Users
WHERE strftime('%d-%m', birthday) = strftime('%d-%m', date('now'))
And INSERT:
INSERT INTO Users (name, birthday)
VALUES ("Name", "2010-09-19")
and I should get those who's birthday is today. I understand that the
problem is with the UTC, but I don't know how to configure it... or where. I
only have an AIR application that uses (and creates if needed) my tables. I
don't know much about databases.
Igor Tandetnik wrote:
>
> Ady Puiu <[email protected]> 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
>
>
--
View this message in context:
http://old.nabble.com/SQLite-System-Time-tp29751139p29752345.html
Sent from the SQLite mailing list archive at Nabble.com.
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
