how to insert date in SqLite Database in android

Question

i want to insert date in Sqlite database i'm stuck at this point. I have taken Date datatype in my pojo class. now i want to insert that thing in my Sqlite Databse using contentvalue so what should i do. it is like this.

 SQLiteDatabase db = getWritableDatabase();
    ContentValues cv = new ContentValues();
    String a = String.valueOf(dp.getDob());
    cv.put(DOB, a);

in pojo class

Date dob;

public DoctorPojo( String name,Date dob,String gender, String adder,String city,
                   String cas,String mobile, Date date,String disease)
{
    this.name = name;
    this.dob = dob;
    this.gender = gender;
    this.adder = adder;
    this.city = city;
    this.cas = cas;
    this.mobile = mobile;
    this.date = date;
    this.disease = disease;
}

but now what should i have to take in my create statement's date? — Dhaval Mistry
– Dhaval Mistry, Commented Apr 12, 2016 at 18:32

Moises Borges dos Anjos · Accepted Answer · 2016-04-12 18:26:23Z

1

According to the Sqlite specficication https://www.sqlite.org/lang_datefunc.html , You have to store Date as String with format YYYY-MM-DD.

It's easy to do that with SimpleDateFormatter.

SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd");
String formattedDate = formatter.format(dp.getDob());
cv.put(DOB, formattedDate );

answered Apr 12, 2016 at 18:26

Moises Borges dos Anjos

514 bronze badges

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

Collectives™ on Stack Overflow

how to insert date in SqLite Database in android

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