SQLite Database compare date with format "mmm dd yyyy hh:mm"

Asked Apr 18 '18 at 07:44

Active Apr 18 '18 at 07:44

Viewed 29 times

I developed an Android Apps with SQLite database.My task is to compare today date with database date. Unfortunately, my date is "mmm dd yyyy hh:mm" and the data type is smalldatetime.

For example, how do I compare "Mar 9 2018 6:00AM" >= todayDate?

If cannot compare, can I change this datetime format "mmm dd yyyy hh:mm" to "yyyy-MM-dd"?

Thank you.

asked Apr 18 '18 at 07:44

Jacky Teaw

Convert your date string to 'Date' and then you can compare tody's date with that date, by simple maths. – Danger Apr 18 '18 at 07:45
Ya, u r correct. Thank for help. – Jacky Teaw Apr 18 '18 at 08:28

SQLite Database compare date with format "mmm dd yyyy hh:mm"

0 Answers0