Ubuntu16.04, Laz 1.8.
I just imported some CSV data with a Date field format of "mm/dd/yyyy"
When I look at the Data in "DBBrowser For SQlite" it has converted the string data from the .CSV into the correct Dates for each Row as a "DateTime" as the column is defined.
When I look at it in Lazarus I get "12/30/1899" for all of the dates.
What do I need to do to get Lazarus to show the correct dates as "DBBrowser For SQlite" shows it?
// For example, DBBrowser For SQlite shows a Date as 9/23/2018
// Lazarus shows
DateTimePicker1.Date:=sqlApps.FieldByName(fldDate).AsDateTime; // 8/3/2017
Label1.Caption:=DateTimeToStr(sqlApps.FieldByName(fldDate).AsDateTime); // 12/30/1899
Label2.Caption:=FloatToStr(sqlApps.FieldByName(fldDate).AsFloat); // 0
Label3.Caption:=sqlApps.FieldByName(fldDate).AsString; // 12/30/1899