CODEWITHSUNDEEP
androidtimestampandroid-sqlite
ramesh
ramesh

Reputation: 4082

timestamp in SQLite - Android

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

Upvotes: 0

Views: 89

Answers (1)

michal.luszczuk
michal.luszczuk

Reputation: 2903

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

Upvotes: 1

Related Questions