How to insert a SQLite record with a datetime set to ‘now’ in Android application?

by

You cannot use the datetime function using the Java wrapper “ContentValues”. Either you can use :

  • SQLiteDatabase.execSQL so you can enter a raw SQL query. 

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

  • Or the java date time capabilities :

    // set the format to sql date time
SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); 
Date date = new Date();
ContentValues initialValues = new ContentValues(); 
initialValues.put("date_created", dateFormat.format(date));
long rowId = mDb.insert(DATABASE_TABLE, null, initialValues);

More Related Contents:

  1. How to add multiple edit text and spinner data into SQLite database?
  2. Hindi font not displying correctly in android [closed]
  3. Why does the application crash when I press the button to insert the values in the table? [duplicate]
  4. Pros and Cons of SQLite and Shared Preferences [closed]
  5. Share SQLite database between 2 android apps?
  6. Location of sqlite database on the device
  7. Android column ‘_id’ does not exist?
  8. Android: upgrading DB version and adding new table
  9. Android P – ‘SQLite: No Such Table Error’ after copying database from assets
  10. How to ignore accent in SQLite query (Android)
  11. Deleting Row in SQLite in Android
  12. How to disable the Clear Data button in Application info of Manage application
  13. How to convert image file data in a byte array to a Bitmap?
  14. Why do I get a “sqlite3: not found” error on a rooted Nexus One when I try to open a database using the adb shell?
  15. Android sqlite how to check if a record exists
  16. Does Android Support JDBC
  17. SQLite Exception no such column when trying to select
  18. android java.lang.IllegalStateException: Couldn’t read row 0, col 0 from CursorWindow
  19. How can I insert image in a sqlite database
  20. Android Save images to SQLite or SDCard or memory
  21. Android Cursor with ORMLite to use in CursorAdapter
  22. Is it possible to apply primary key on the text fields in android database
  23. What is The use of moveToFirst () in SQLite Cursors
  24. sqlite example program in android [closed]
  25. How to check database on not rooted android device
  26. SQLite android column not found
  27. SQlite – Android – Foreign key syntax
  28. Inserting values to SQLite table in Android
  29. Queries with prepared statements in Android?
  30. SQLiteOpenHelper onUpgrade() Confusion Android

Leave a Comment