CODEWITHSUNDEEP
javaandroidsqlitetimestamp
user3245658
user3245658

Reputation: 93

Sqlite : Comparing timestamp value stored in a column to current Date

I store information in a sqlite database table as follows: ActionDate column is of type : DEFAULT CURRENT_TIMESTAMP

    private String getDateTime() {
        SimpleDateFormat dateFormat = new SimpleDateFormat(
                "yyyy-MM-dd HH:mm:ss", Locale.getDefault());
        Date date = new Date();
        return dateFormat.format(date);
}

I want to write an SQL query that returns all rows in my table having ActionDate value as today's date from sqlite DB. However as ActionDate is of type timestamp what is the most appropriate way to convert it to todays date.

Upvotes: 0

Views: 2347

Answers (1)

Kakarot
Kakarot

Reputation: 4252

If you want current date then use the following query : 

 SELECT date('now');

To get all columns in your table having ActionDate equal to todays date use the below query :

select * from table where strftime('%Y-%m-%d ', datetime(ActionDate, 'unixepoch'))  = date('now)' ;

more info on SQLite Date & Time queries can be found here

Upvotes: 2

Related Questions