vendredi 13 février 2015

why sqlite gives different time rather than current time?

I have created a table with schema cur_date date, cur_time time. I want to insert the current time and date into the table. When I do so with



INSERT INTO timeDemo VALUES(date(),time());


and



SELECT* FROMtimeDemo


it returns a row with current date but a different time. I executed this query at 4:03 PM of system time, but the row has 10:22 .


How can I fix it? I run these from cmd.exe .


Aucun commentaire:

Enregistrer un commentaire