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: 
  • Don’t miss your chance to experience Discovery Summit Europe at our best available rate! Early bird registration through 31 Oct.
  • Graph Builder Toolbar streamlines interactive graphing. Creates shortcuts on Report and GraphBuilder Helpers toolbars. Download and install the extension.
  • JMP will suspend normal business operations for our Rest and Recharge Day on Friday, October 2, 2026.
    Regular business hours will resume on Monday, October 5, 2026.

JMP Knowledge Base

Choose Language Hide Translation Bar
JMP® date columns are exported as character data types through ODBC
Created: Nov 30, 2022 02:28 PM  |  Last Modified: Jan 10, 2023 10:07 AM

When exporting a JMP® data table to a database using ODBC, JMP exports the data as either character (CHAR or NCHAR) or numeric (FLOAT or DOUBLE PRECISION) data types. If a column is defined as a JMP date or time, it exports as character data. Changing the data type to a proper date format would need to be handled by the receiving database.

 

[Previously JMP Note 46350]

0 Kudos
Details
Operating System
macOS Windows
Products JMP JMP Pro

Recommended Articles