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: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
Choose Language Hide Translation Bar
djhanson
djhanson
Level V

How to "yyyy-mm-dd hh:mm:ss" format (and not w/ the "T")

Apr 25, 2013 10:24 PM (5045 views)

Does anyone know if JSL can format time in columns as "yyyy-mm-dd hh:mm:ss", that is a space between the dd and hh and not the capital "T" that JMP wants to insert?  I have tried this, but it ends up converting to serial, exactly not what I want of course.  Likewise, I do not like that capital "T" stuff that JMP does period.  The format I've mentioned is highly used in industry and I'm hoping JSL/JMP can someway support it.

Reason being: SQL uses this format, that is a space between dd and hh and has no idea what to do with a capital "T" of course.  So when saving a .csv with time data via JSL, this gets all messed up.  thanks... dj

0 Kudos
4 REPLIES 4

Re: How to "yyyy-mm-dd hh:mm:ss" format (and not w/ the "T")

Apr 26, 2013 06:25 AM (4545 views)  |  Posted in reply to message from djhanson 04-25-2013

I'm not a JMP guy so can't give you the answer. Are you aware though that the datetime format with a "T" you don't like is an ISO standard?

0 Kudos
ms
Super User (Alumni) ms
Super User (Alumni)

Re: How to "yyyy-mm-dd hh:mm:ss" format (and not w/ the "T")

Apr 26, 2013 06:54 AM (4545 views)  |  Posted in reply to message from djhanson 04-25-2013

Try set format to "Local Date Time h.m.s". In my setting that results in e.g. 1995-12-12 10.00.00 (this is also preserved in CSV export). I can easily change my system to use 1995-12-12 10:00:00 or any other format which JMP then uses (relaunch required, at least on my Mac).

0 Kudos
djhanson
djhanson
Level V

Re: How to "yyyy-mm-dd hh:mm:ss" format (and not w/ the "T")

Apr 26, 2013 10:56 AM (4545 views)  |  Posted in reply to message from ms 04-26-2013

Thanks Patrick - I did not realize it was an ISO standard.  I wish SQL would use it:).

MS, thanks for that idea.

I tried the following, as JSL hover over states slightly different, but both gave me slashes ("/") and not dashes ("-").

:MyTime<<Format("Local Date Time h.m.s");

:MyTime<<Format("Locale Date Time h:m:s");

I'm using JMP 9.0.3, else wonder if there is some global preference maybe I need to set to get this format ("yyyy-mm-dd hh:mm:ss")?  dj

0 Kudos
ms
Super User (Alumni) ms
Super User (Alumni)

Re: How to "yyyy-mm-dd hh:mm:ss" format (and not w/ the "T")

Apr 26, 2013 04:48 PM (4545 views)  |  Posted in reply to message from djhanson 04-26-2013

JMP's local date time format is supposed to use the settings of your OS. What I meant was that you can globally change the date/time format on your computer to match the format you desire. Unfortunately that may interfere with other software but it's easy to revert. I think the use of slashes is US tradition. Try to pick another country in the date time settings (on the mac it's a drop-down menu and detailed customization options in a system control panel. I don't have access to Windows right now but it should be there somewhere...).

0 Kudos