| 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 12.02 years ago |
Created: |
2013-06-17 12:23:50 12.04 years ago |
| 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. | ||||