Home  >  Blog  >   Snowflake  > 

How to Round Timestamps in Snowflake

We use timestamps to keep the records of the data online or on the computer. The timestamp shows when certain information is exchanged, created, deleted or modified. In this blog, we will discuss rounding the timestamps.

Rating: 4.2
  
 
253
  1. Share:
Snowflake Articles

Snowflake - Round Timestamps

Truncating or Rounding the Timestamps is useful for “grouping by time.” Following are 
some approaches:

DATA_TRUNC function
select date_trunc(‘second’ , now())

Predefined Functions in Snowflake

If we round by year, we can use the year() function (or month(), day(), week(), etc:

select year(getdate()) as year;
Round and Format the result as the string, e.g. ‘09-2021’
But, if we want to distinguish between the months of end years, we have to utilise 
“to_varchar()” function:
select to_varchar(getdate(), ‘mm-yyyy’);
select to_varchar(getdate(), ‘dd-mm-yyyy’);
select to_varchar(getdate(), ‘dd-mm-yyyy hh’);
select to_varchar(getdate(), ‘dd-mm-yyyy hh:mm’);
select to_varchar(getdate(), ‘dd-mm-yyyy hh:mm:ss’);

 MindMajix YouTube Channel

Conclusion

Timestamps are essential to keep the records while information is created, exchanged, and deleted online. I hope this blog provides you with sufficient information about rounding the timestamp.

Snowflake Related Articles


▶  Snowflake vs Redshift
▶  Snowflake vs BigQuery
▶  Snowflake vs Databricks
▶  Snowflake vs Azure
▶  Snowflake vs Hadoop
▶  Snowflake Time Travel

If you have any queries, let us know by commenting below.

Join our newsletter
inbox

Stay updated with our newsletter, packed with Tutorials, Interview Questions, How-to's, Tips & Tricks, Latest Trends & Updates, and more ➤ Straight to your inbox!

Course Schedule
NameDates
Snowflake TrainingDec 06 to Dec 21
Snowflake TrainingDec 10 to Dec 25
Snowflake TrainingDec 13 to Dec 28
Snowflake TrainingDec 17 to Jan 01
Last updated: 04 December 2022
About Author
Keerthi Sai

Keerthi Sai is a Senior Writer at Mindmajix with tons of content creation experience in the areas of cloud computing, BI, Perl Scripting. She also creates content on Salesforce, Microstrategy, and Cobit.