Hi All,
I want to store MFC date (CTime or COleDateTime) value in sqlite, but don't know what is the best way to store it. I am running into trouble when I store date as Text in sqlite, because I can't no longer apply sqlite date time functions( datetime(), date()...) to it. Result in I can't do a order by the date filed.
The other question would be does sqlite have date limits (Upper Bound and Lower Bound) for the datetime() functions.
Many thanks,
Ming
