System.Data.SQLite
View Ticket
Not logged in
Ticket UUID: 64b00c146ba3b7e11557049e8f1370de52f35d65
Title: Aggregate functions on DateTime do not honor DateTimeFormat =Ticks
Status: Closed Type: Incident
Severity: Important Priority: Medium
Subsystem: Convert Resolution: Works_As_Designed
Last Modified: 2013-06-25 22:42:52
Version Found In: 3.7.12
User Comments:
anonymous added on 2013-06-17 12:23:50:
Using the DateTimeFormat = Ticks as option

"select max(timestampColumn) from someTable" returns the value as tick without performing the conversion to DateTime as it would without using aggregate function.

mistachkin added on 2013-06-25 22:42:52:
The MAX(x) expression has an integer type affinity; therefore, the DateTime
handling performed by System.Data.SQLite does not apply to it.