---
title: "Discussion on \"Working with Date and Time in Snowflake\" | Hashnode"
description: "Discussion on \"Working with Date and Time in Snowflake\". By the end of this article, you have learned some frequently used functions used in Snowflake when dealing with Date and Time.\n\nTo get the current date\n SELECT CURRENT_DATE AS “CURRENT DATE”;\n\n Output:\n \n\nTo get a current timestamp\n SELECT CURRENT_TI..."
url: "https://hashnode.com/posts/working-with-date-and-time-in-snowflake/63c3af335c7053ca2b0da8dd"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [Working with Date and Time in Snowflake](https://datanet.hashnode.dev/working-with-date-and-time-in-snowflake?utm_source=hashnode&utm_medium=feed)

By the end of this article, you have learned some frequently used functions used in Snowflake when dealing with Date and Time. To get the current date SELECT CURRENT\_DATE AS “CURRENT DATE”; Output: To get a current timestamp SELECT CURRENT\_TI...

Jan 15, 2023 · 3 min read · datanet.hashnode.dev  
Updated Feb 27, 2023  
Read the article

-   [#sqltutorial](https://hashnode.com/tag/sqltutorial)
-   [#snowflake](https://hashnode.com/tag/snowflake)
-   [#sql](https://hashnode.com/tag/sql)

## Written by

[Shikhar Joshi](https://hashnode.com/@ShikharJoshi)

@ShikharJoshi

  
[View profile](https://hashnode.com/@ShikharJoshi)

## Responses

Markdown supported · ⌘↵ to post

No responses yet.
