06 Oct 19 · npack ·       Add to Favorites  

Extract command syntax in Snowflake

Extracts the specified date or time part from a date, time, or timestamp

SELECT EXTRACT(DAY FROM DATE '2013-12-25') as the_day;
select extract(year from to_timestamp('2013-05-08T23:39:20.123-07:00')) as v

npack

posted on 06 Oct 19

Enjoy great content like this and a lot more !

Signup for a free account to write a post / comment / upvote posts. Its simple and takes less than 5 seconds

Copied