Current_Timestamp to CST format

michael4 · October 23, 2025, 4:42pm

I’m trying to convert the current_timestamp field to Central Standard Time. The format of current_timestamp shows as 2025-10-23T09:42:00.696000-07:00. I’d like to convert this to CST and get rid of the T. Any suggestions?

Topic		Replies	Views
Using a non-UTC timestamp when calculating source freshness Archive	2	4119	June 9, 2020
Change the Time Zone of Snapshot Attributes Archive	0	3033	June 18, 2020
Check recency-source for model in DBT cloud Help data-quality , best-practice , dbt-cloud	4	3488	December 2, 2022
How get curent date in dbt CLI? Help	13	12259	March 24, 2023
Guide/Notes on moving from Postgres to Snowflake Show and Tell snowflake , migration , postgres	0	5214	August 13, 2019