The user would like to use the default timestamp to be displayed in the SQL results.
The default timestamp format is "YYYY-MM-DD HH24:MI:SS.FF7".
However, the user observed the following discrepancies :
- SAP HANA Studio displays data format like "Jun 18, 2019 9:14:43.601212 AM" as a result.
- SAP Database Explorer displays data format like "2019-05-22 14:32:19.440776" as a result.
- SAP HANA Platform 1.0
- SAP HANA Platform 2.0
- SAP HANA Studio (All versions)
SAP HANA Studio; Datetime; Format; YYYY-MM-DD; Datetime Data Types; YYYY-MM-DD HH24:MI:SS.FF7; , KBA , HAN-STD-ADM-DBA , SAP HANA Studio (Eclipse) Admin Tooling , Problem
About this pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.