06 Oct 19 ·  nVector in Snowflake ·        Bookmark ·  Report ·  More actions.. Lock comments ·  Pin thread

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


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