Hi,
In my application, I use a lot of DateTime field. I have a lot of query which use a dateTime field. For example:
- Select all data for a selected week
- Select all data for a selected month, or year
So, what is the best method to handle these query :
-> Use a DateTime field, but with SQLite, function Year(), Month(), does not exist. So a lot of supplementary tasks should be done for getting the year and the month information from the DateTime field.
-> Split the DateTime information into 3 fields : year, month, day. So it's easy to make the previous query with these information.
What is your opinion ?