I want to format the dtime2 field in my query:
SELECT FORMAT(MAX(dTime),'yyyy-MM-dd hh:mm:ss') FROM triangulations
SELECT MAX(dTime) FROM triangulations
In your format string,
hh means you want the hours in the 12-hour-cycle format, so 3 and 15 are always 3 (AM and PM). Use
HH to get them in the 24-hour-cycle format:
Relevant docs, scroll down to the list of format specifiers.