[Bug]: Snowflake DB - data in Date / Time Format on querying, is displayed in a different number format

[btsgh]

Is there an existing issue for this?

• [X] I have searched the existing issues

Description

When I run a select query on Snowflake DB to pull in data the Date and Time columns show data in incorrect format.

Steps To Reproduce

1. Connect to the following Snowflake DB. Account name - gv14678.central-india.azure
 Warehouse - COMPUTE_WH
 Database - NEWDBAPARNA
 Default Schema - PUBLIC 
Role - ACCOUNT ADMIN
 User name - Aparna
 Password - Snowflake123
2. Run a query - SELECT * FROM CALL_CENTER_APARNA;
3. Note the columns - CC_START_DATE, CC_END_DATE, CC_CREATIONTIME

The data in these columns should be in the form of Date and Time formats, but they are not.

Public Sample App

No response

Version

Release