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: 

Discussions

Solve problems, and share tips and tricks with other JMP users.
%3CLINGO-SUB%20id%3D%22lingo-sub-6619%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%22yyyy-mm-dd%20hh%20%3A%20mm%20%3A%20ss%22%ED%98%95%EC%8B%9D%20(%20%22T%22%EA%B0%80%EC%97%86%EB%8A%94%20%ED%98%95%EC%8B%9D)%20%EB%B0%A9%EB%B2%95%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-6619%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%26lt%3Bmeta%20http-equiv%3D%22Content-Type%22%20content%3D%22text%2Fhtml%3B%20charset%3DUTF-8%22%20%2F%26gt%3B%3CP%3E%EB%88%84%EA%B5%AC%EB%93%A0%EC%A7%80%20JSL%EC%9D%B4%20%22yyyy-mm-dd%20hh%20%3A%20mm%20%3A%20ss%22%EB%A1%9C%20%EC%97%B4%EC%9D%98%20%ED%98%95%EC%8B%9D%EC%9D%84%20%EC%A7%80%EC%A0%95%ED%95%A0%20%EC%88%98%20%EC%9E%88%EB%8A%94%EC%A7%80%20%EC%95%8C%EA%B3%A0%20%EC%9E%88%EC%8A%B5%EB%8B%88%EA%B9%8C%3F%20%EC%A6%89%2C%20dd%EC%99%80%20hh%20%EC%82%AC%EC%9D%B4%EC%9D%98%20%EA%B3%B5%EB%B0%B1%EC%9D%B4%EB%A9%B0%20JMP%EA%B0%80%20%EC%82%BD%EC%9E%85%ED%95%98%EB%A0%A4%EB%8A%94%20%EB%8C%80%EB%AC%B8%EC%9E%90%20%22T%22%EA%B0%80%20%EC%95%84%EB%8B%8C%20%EA%B3%B5%EB%B0%B1%EC%9E%85%EB%8B%88%EA%B9%8C%3F%20%EB%82%98%EB%8A%94%20%EC%9D%B4%EA%B2%83%EC%9D%84%20%EC%8B%9C%ED%97%98%ED%95%B4%20%EB%B3%B4%EC%95%98%EC%A7%80%EB%A7%8C%2C%20%EA%B7%B8%EA%B2%83%EC%9D%80%20%EC%A7%81%EB%A0%AC%EB%A1%9C%20%EB%B3%80%ED%99%98%EB%90%98%EC%96%B4%20%EB%81%9D%EB%82%9C%EB%8B%A4.%20%EB%AC%BC%EB%A1%A0%20%EB%82%B4%EA%B0%80%20%EC%9B%90%ED%95%98%EB%8A%94%20%EA%B2%83%EC%9D%80%20%EC%95%84%EB%8B%88%EB%8B%A4.%26nbsp%3B%20%EB%A7%88%EC%B0%AC%EA%B0%80%EC%A7%80%EB%A1%9C%20%EB%82%98%EB%8A%94%20JMP%EA%B0%80%ED%95%98%EB%8A%94%20%EC%9E%90%EB%B3%B8%20%22T%22%EB%A5%BC%20%EC%A2%8B%EC%95%84%ED%95%98%EC%A7%80%20%EC%95%8A%EB%8A%94%EB%8B%A4.%26nbsp%3B%20%EB%82%B4%EA%B0%80%20%EC%96%B8%EA%B8%89%20%ED%95%9C%20%ED%98%95%EC%8B%9D%EC%9D%80%20%EC%82%B0%EC%97%85%EC%97%90%EC%84%9C%20%EB%A7%8E%EC%9D%B4%20%EC%82%AC%EC%9A%A9%EB%90%98%EA%B3%A0%20%EC%9E%88%EC%9C%BC%EB%A9%B0%20JSL%20%2F%20JMP%EA%B0%80%EC%9D%B4%EB%A5%BC%20%EC%A7%80%EC%9B%90%ED%95%A0%20%EC%88%98%20%EC%9E%88%EA%B8%B0%EB%A5%BC%20%ED%9D%AC%EB%A7%9D%ED%95%A9%EB%8B%88%EB%8B%A4.%3C%2FP%3E%3CP%3E%3C%2FP%3E%3CP%3E%EC%9D%B4%EC%9C%A0%20%3A%20SQL%EC%9D%80%20dd%EC%99%80%20hh%20%EC%82%AC%EC%9D%B4%EC%9D%98%20%EA%B3%B5%EB%B0%B1%EC%9D%B4%EB%A9%B0%2C%20%EB%8C%80%EB%AC%B8%EC%9E%90%20%22T%22%EB%A1%9C%20%EB%AC%B4%EC%97%87%EC%9D%84%20%ED%95%B4%EC%95%BC%ED%95%A0%EC%A7%80%20%EB%AA%A8%EB%A5%B4%EB%8A%94%EC%9D%B4%20%ED%98%95%EC%8B%9D%EC%9D%84%20%EC%82%AC%EC%9A%A9%ED%95%A9%EB%8B%88%EB%8B%A4.%26nbsp%3B%20%EB%94%B0%EB%9D%BC%EC%84%9C%20.csv%EB%A5%BC%20JSL%EC%9D%84%20%ED%86%B5%ED%95%B4%20%EC%8B%9C%EA%B0%84%20%EB%8D%B0%EC%9D%B4%ED%84%B0%EC%99%80%20%ED%95%A8%EA%BB%98%20%EC%A0%80%EC%9E%A5%ED%95%98%EB%A9%B4%EC%9D%B4%20%EB%AA%A8%EB%93%A0%20%EA%B2%83%EC%9D%B4%20%EC%97%89%EB%A7%9D%EC%9D%B4%EB%90%A9%EB%8B%88%EB%8B%A4.%26nbsp%3B%20%EA%B0%90%EC%82%AC...%20DJ%3C%2FP%3E%3C%2FLINGO-BODY%3E
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 (6685 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 (6185 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 (6185 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 (6185 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 (6185 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

Recommended Articles