Date issue with SQLite

[dolevo]

Hi,

I have a database application in Qt and it uses SQLite. In the beginning, I stored all the dates as string in the database in "dd.MM.yyyy" format. Now, I need to use the following SQL statement but it doesn't work out:

@SELECT sold_date, title, sold_price FROM adv WHERE userid=2 AND sold_date > '01/01/2015'

Is there any way to convert my column to a comparable format in an easy way? Otherwise I need to change the format to another one that SQLite understands I suppose. Could anyone help me out?

[dolevo]

Never mind, I have all the data in the date column in "yyyy-MM-dd" format and now it works as expected.

[bagavathikumar]

The default date format is YYYY-MM-DD only. So write a small code to change the format of the value, then change the data type of the column.