timestamp problem in android sqlite3

Question

I want insert the current date and time into my table.... I used this query

insert into tbl_reminder values("Description",current_timestamp);

but it insert the wrong time... actually the timestamp in my emulator is 2010-09-16 18:40:06 but the inserted timestamp value is 2010-09-16 13:10:06 what i do to insert the exact time...

current_timestamp is a default keyword to insert the current time in database...so i didn't give any value for that... — Kandha
– Kandha, Commented Sep 16, 2010 at 13:21

st0le · Accepted Answer · 2010-09-16 13:21:56Z

1

Insert it enclosed within Quotes, the date will be stored as a string.

sqlite doesn't has a Date datatype.

Now, the following is just incase you are planning to use the Date column for Comparisions...

Speaking from experience, i would advice you store it as Long Integer, as a Unix Timestamp, it lets you do Comparison between dates, which would otherwise be very difficult.

You'll obviously have to convert it to-and-fro but in the long run it's a better stratergy.

answered Sep 16, 2010 at 13:21

st0le

33.6k8 gold badges93 silver badges90 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

timestamp problem in android sqlite3

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related