JMP Query Uses datetime2 format correctlyWhen using query builder the data type "datetime2" implements a character rather than a date and time. This format seems to be gaining in popularity as it adds more granularity but the only solution to get it to date time format correctly currently requires custom sql queries. My suggestion is to have "datetime" and "datetime2" both have a date and time format.

Data AccessRe: JMP Query Uses datetime2 format correctlyI would love to know how others are handling this issue.