This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
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: 
Submit your abstract to the call for content for Discovery Summit Americas by April 23. Selected abstracts will be presented at Discovery Summit, Oct. 21- 24.
Discovery is online this week, April 16 and 18. Join us for these exciting interactive sessions.
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 (4086 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 (3586 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 (3586 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 (3586 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 (3586 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