Data360 Analyze

 View Only
Back to discussions
Expand all | Collapse all

Dates/Times idisplayed in Oracle database, Lavastorm, Data3Sixty, and Excel output

  • 1.  Dates/Times idisplayed in Oracle database, Lavastorm, Data3Sixty, and Excel output

    Employee
    Posted 06-11-2019 11:37

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Trying to understand the formatting of dates/times in Data3Sixty. Here are the same 10 records from the Oracle database, Lavastorm, Data3Sixty and then Excel output from Data3Sixty. Can we set a conf.prop value to display data correctly?

    Oracle

    6/11/2019 11:21:49 AM
    6/11/2019 11:19:00 AM
    6/11/2019 11:16:00 AM
    6/11/2019 11:15:51 AM
    6/11/2019 10:56:00 AM
    6/11/2019 10:56:00 AM
    6/11/2019 10:56:00 AM
    6/11/2019 10:56:00 AM
    6/11/2019 10:56:00 AM
    6/11/2019 10:52:00 AM

    Lavastorm

    CREATED_DATE
    2019-06-11 11:21:49
    2019-06-11 11:19:00
    2019-06-11 11:16:00
    2019-06-11 11:15:51
    2019-06-11 10:56:00
    2019-06-11 10:56:00
    2019-06-11 10:56:00
    2019-06-11 10:56:00
    2019-06-11 10:56:00
    2019-06-11 10:52:00

    Data3Sixty

    CREATED_DATE
    2019-06-11T06:21:49-0500
    2019-06-11T06:19:00-0500
    2019-06-11T06:16:00-0500
    2019-06-11T06:15:51-0500
    2019-06-11T05:56:00-0500
    2019-06-11T05:56:00-0500
    2019-06-11T05:56:00-0500
    2019-06-11T05:56:00-0500
    2019-06-11T05:56:00-0500
    2019-06-11T05:52:00-0500

    Excel output from Data3Sixty

    CREATED_DATE
    2019-06-11 06:21:49
    2019-06-11 06:19:00
    2019-06-11 06:16:00
    2019-06-11 06:15:51
    2019-06-11 05:56:00
    2019-06-11 05:56:00
    2019-06-11 05:56:00
    2019-06-11 05:56:00
    2019-06-11 05:56:00

    2019-06-11 05:52:00

     


  • 2.  RE: Dates/Times idisplayed in Oracle database, Lavastorm, Data3Sixty, and Excel output

    Employee
    Posted 06-26-2019 04:49

    The Data3Sixty Analyze Data Viewer displays a human-readable representation of the datetime value from a Datetime type field using the canonical ISO 8601 format. The 'T' delimiter is displayed between the date and time elements of the datetime value. The displayed value also displays the offset from UTC for the datetime value (e.g. "-0500") for the user's locale.

    When a datetime value is written to an Excel/ CSV file the representation of the datetime value is timezone-unaware.

    We are considering whether the product can be enhanced to provide users with additional display preference options for datetime values, e.g. to provide the display of in client-local time or in server-local time.