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

Follow

Donald Graham

• June 11, 2019 18:36

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

0

• 

  Adrian Williams

  • June 26, 2019 11:48

  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.

  0

  Comment actions Permalink

Please sign in to leave a comment.