We recommend switching to the latest versions of Edge, Firefox, Chrome or Safari. Using Internet Explorer will result in a loss of website functionality.

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


1 comment

  • Avatar
    Adrian Williams

    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.

    Comment actions Permalink

Please sign in to leave a comment.