timestamp in SQLite - Android

Question

I am new to android and creating an application with sqlite database.

I am using SQLite browser to create database in android. I just want to create a time stamp filed just like mysql. But in SQLite browser there is no such field like timestamp.

My little question is is it possible to add the timestamp field in sqlite and query order by the timestamp field

michal.luszczuk · Accepted Answer · 2014-02-04 16:39:20Z

1

There is no any date format in sqlite only TEXT please read this link You should hold your Date as text in ISO8601 ("YYYY-MM-DD HH:MM:SS.SSS") format

answered Feb 4, 2014 at 16:39

michal.luszczuk

2,9031 gold badge18 silver badges22 bronze badges

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

2 Comments

ramesh Over a year ago

Thanks for your reply. So if I just wanna sort the query according to date time how we can do this ?

michal.luszczuk Over a year ago

Sorting TEXT type column with your data in ISO8601 format should work well because it got Lexicographical order

Collectives™ on Stack Overflow

timestamp in SQLite - Android

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related