How to Query Date and Time in Snowflake

Snowflake - Query Date and Time

We use the following code to get data and time immediately:

select current timestamp;
select systimestamp();
select getdate();
select localtimestamp();

Find the rows between two timestamps or data

select *
from events1
where event_date between ‘2022-05-19’ and ‘2022-06-19.’

select *
from events1
where event_date between ‘2022-03-09  10:01:00’ and  ‘13:30:00.’

Find rows created within last week:

select*
from events1
where event_data > (select dateadd(week, -1, getdate()));

Conclusion

We use the “Select” statement and “WHERE” clauses for querying the date and time. We can get the date and time of a particular interval. I hope this information is adequate for querying the date and time.

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.