User Community
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Due to the recently reported Microsoft outage, users may be temporarily unable to access My JMP or experience a delay receiving their verification codes. If you have previously installed JMP on your computer, this outage should not impact your ability to access the software. My JMP services will be restored as soon as Microsoft resolves this issue.
  • Image to Table JMP extension imports single or batch images as data tables. Useful to extract curves from pictures or convert image data to curve data to use in analyses like Functional Data Explorer. Download and install the extension.

JMP Wish List

We want to hear your ideas for improving JMP. Share them here.
Choose Language Hide Translation Bar
0 Kudos

JMP Query Uses datetime2 format correctly

Status: New Submitted by on ‎10-26-2020 09:50 AM
1 Comment (1 New)

When 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. 

 

pickerins_0-1603720061630.png

 

1 Comment
pickerins
Level II
‎01-04-2021 04:12 PM
‎01-04-2021 04:12 PM

I would love to know how others are handling this issue.