Hi Guys, One of the columns in my grid variable is Datetime format. I get the current timestamp using select current_timestamp(). Then I use a fixed flow component and output to a table in snowflake

Matillion ETL
1

When I throw this in a table in snowflake the date is correct but it is not giving me the specific time.The time is generic it comes up as 00:00:00. But I want the specific time. How do I get this.

2

Use the Below Function:

select date_trunc('MINUTE',current_timestamp()) AS "TRUNCATED TO MINUTE"

 

Link to the documentation:

https://docs.snowflake.com/en/sql-reference/functions/date_trunc.html

 

Use the Above Funtion in Calculator Component, and then map the result to your desired column.

 

Happy For Sharing My Knowledge !