BioBytes Messages: 307 Registered: October 2008 Location: France
Senior Member
Hi Paco,
Sorry for late reply due to professional occupation. I was just on the way to reply the same answer than Mirek as I got the same assertion message than you when using an SqlArray to render date fields.
As you know Sqlite does not have specific field format for datetime data which are recorded as string (Text if I remember well). So this is not possible to go to SetConvert function in SqlArray.AddColumn().
One way is perhaps to parse all columns that contains date data to the time format you wish.