How to insert current date in sqlite from android application

Question

I want to insert current date in SQLite database datetime type field. How can I do this?

UPDATE : Using mDb.execSQL("INSERT INTO " + DATABASE_TABLE + " VALUES (datetime()) ");

I am able to insert like date_created=2012-10-10 13:02:08 and I want this format 10 Oct 2012 12:48 how to achive this?

score 10 · Answer 1 · answered Oct 10 '12 at 07:22

I prefer the following ways to get it done:

Create the table with a default settings to put current datetime automatically. For example:
```
ColumnName DATETIME DEFAULT CURRENT_TIMESTAMP
```

Create SimpleDateFormat and convert current date into SQL format string. For example:

SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
String strDate = sdf.format(new Date());

ContentValues values = new ContentValues();
values.put("ColumnName", strDate);

score 1 · Answer 2 · edited May 23 '17 at 11:44

1

You can use:

mDb.execSQL("INSERT INTO " + DATABASE_TABLE + " VALUES (datetime()) ");

check: https://stackoverflow.com/a/819605/1434631

edited May 23 '17 at 11:44

Community

1
1

answered Oct 10 '12 at 07:19

Nermeen

15,883
5
59
72

Thanks for the response I used it and it is giving result like date_created=2012-10-10 13:02:08 and I want this format 10 Oct 2012 12:48 how to achive this. – Ankit HTech Oct 10 '12 at 07:37

score 0 · Answer 3 · answered May 31 '13 at 11:27

   ContentValues coloumnVlues = new ContentValues();
   //SimpleDateFormat dateFormat = new SimpleDateFormat("YYYY-MM-dd HH:mm:ss");
   Date date = new Date();
   coloumnVlues.put("fname", fname);

   // inserted date in database like May 31, 2013 10:42:53 AM it's simulator datetime
   coloumnVlues.put("created_date", DateFormat.getDateTimeInstance(). format(date));

their is no need to use SimpleDateFormat.

you get datetime from database the example given in below link

http://www.sqlite.org/lang_datefunc.html

How to insert current date in sqlite from android application

3 Answers3