| Ticket Hash: | 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:
(text/x-fossil-plain)
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: (text/x-fossil-plain) The MAX(x) expression has an integer type affinity; therefore, the DateTime handling performed by System.Data.SQLite does not apply to it. | ||||
