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
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