Dates/Times idisplayed in Oracle database, Lavastorm, Data3Sixty, and Excel output
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
|
-
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.
Please sign in to leave a comment.
Comments
1 comment