DateTime field not showing Time

Completed
Avatar
KGBhai
Created

DB: Snowflake

1st column in the grid is NOT showing time.

SELECT CONVERT_TIMEZONE('UTC', CURRENT_TIMESTAMP())::TIMESTAMP_NTZ, CONVERT_TIMEZONE('UTC', CURRENT_TIMESTAMP()), CURRENT_TIMESTAMP()
  FROM DUAL;

But Extractor has it:

+-----------------------------------------------------------+------------------------------------+
 CONVERT_TIMEZONE('UTC', CURRENT_TIMESTAMP())::TIMESTAMP_NTZ 2025-06-11 17:48:19.870000000        
+-----------------------------------------------------------+------------------------------------+
 CONVERT_TIMEZONE('UTC', CURRENT_TIMESTAMP())                2025-06-11 17:48:19.870000000 +00:00 
+-----------------------------------------------------------+------------------------------------+
 CURRENT_TIMESTAMP()                                         2025-06-11 13:48:19.870000000 -04:00 
+-----------------------------------------------------------+------------------------------------+


This is my settings:

 

 

 

 

 

Votes

1

Share

2 comments
Avatar
Anastasia Zhukova
Created

The settings from Appearance and Behavior | System Settings | Date Formats configure how DataGrip should format the date and time stamps in various places of the UI (e.g., in the notifications, different tool window logs, etc.). Please share a screenshot of your settings from the Custom Date/Time Formats section under Database | Data Editor and Viewer, as it defines date and time formats for the Data Viewer.

1
Avatar
KGBhai
Created

Thanks !

Adding the missing “HH:mm” fixed the issue.
 

0

Please sign in to leave a comment.