jmp not recognize sql datetime2 datatype as date

[#1]

When I query datetime2 data type columns from sql tables they come back as character variables rather than numeric dates in the JMP data type. how do I cast convert in the sql so that it will come back as a numeric column type when I query with JMP? datetime? 

[#2]

What is the structure of the data when it is returned as a character string?  (i.e. 01/15/2022, or 01AN2022, or ....)

[#3]

I have the same problem. We use the German Version of JMP. When I import a table from Microsoft SQL-Server I get a date if the datatype is datetime (well) and when I import the datatime2(7) I get only a string.

Example for datetime (Correct)

In SQL-Server:  Import in JMP:  Query result:  

Example for datetime2 (not recognized as date, only as string)

In SQL-Server:   Import in JMP:  Query result:

How can I get datetime2 is date in JMP?

Thanks