みなさん、こんにちは、<\/P>
<\/P>
タイムスタンプを特定の形式で取得しようとしています:YYYY-MM-DDThh:mm:ss.s しかし、それができません。<\/P>
例としては、次のような形式にする必要があります:2017-02-20T23:16:45.7<\/P>
これは可能でしょうか?もし可能なら、必要な式は何ですか?<\/P>
ありがとうございます、<\/P>
ティム<\/P><\/BODY><\/HTML>
Hold on, why are you using this in expression? Just use the TIMESTAMP value method and yyyy-MM-dd HH:mm:ss as the value info
I pulled the decimal from their Date Field description:
D – Date and Time fields are as defined by the International Organization for Standardization (ISO) 8601 standard and are a NENA requirement. Date and time use ISO 8601 compliant formats which are in the format of YYYY-MM-DDThh:mm:ss.sTZD and conform to a TimeStamp as defined in NENA-STA-010 [1] , which in turn conforms to W3C dateTime format. Example: 2014-02-20T23:16:45.7-05:00 744 2014 = the Year 02 = the Month 20 = the Day NENA Standard for NG9-1-1 GIS Data Model NENA-STA-006.1-201X, Month Day, Year [MM/DD/YYYY] Page 29 of 86 23 = the Hour 16 = the Minute 45.7 = the Seconds and decimal fraction of seconds –05:00= the Offset from UTC Note: The Offset from Coordinated Universal Time (UTC) is the optional separator to indicate the time zone designation, which in this example is -5:00 to indicate the local Eastern Standard Time (EST) time difference from UTC.
I'll have to check out editor tracker!
I often wonder about the practicality of NENA standards; I don't know what percentage I'm NENA compliant, but somehow we get the right truck or car to the right address in the shortest amount of time...
Looking at that document, I don't see tenths of a second. Currently I provide a date of when a record was last modified. ( I expect the NENA black Suburban to pull up any minute now and take me away.) Instead of AA, you could try using the Editor Tracker and specify UTC...
I know it is crazy, I am just looking through the upcoming NENA standards
This is what I am talking about:
1403 5.37 Date Updated 1404 Description: The UTC date and time that the record was created or last modified. This 1405 value SHOULD be populated upon modifications to attributes, geometry, or both. 1406 Domain: Restricted to ISO 8601 compliant values in Coordinated Universal Time (UTC). 1407 Values are not allowed to be in the future. 1408 Example: 2010-12-19T20:01:29-05 (representing a record updated on December 19, 2010 1409 at 8:01 and 29 seconds PM US Eastern Standard Time)
Tim- after spending a little time with google I notice that t or T is often used to designate PM, but in a 24 hour clock, do you need to specify that? (2017-02-20T23:16:45.7) Tenths of a second seems pretty extreme; I haven't found a format for that yet.....
timw1984
サインインしたメンバーは投稿、更新のフォローなどができます。初めてですか?無料アカウントを登録してください。
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.