These functions are alternatives to using the DATE_PART (or EXTRACT) function with the equivalent date part (see Supported date and time parts). A date or a timestamp, or an expression that can be evaluated to a date or a timestamp. This function returns a value of type NUMBER.
tear* / day* / week* / month / quarter – snowflake documentation, gear* / day* / week* / month / quarter – snowflake documentation, hear* / day* / week* / month / quarter – snowflake documentation, uear* / day* / week* / month / quarter – snowflake documentation, 7ear* / day* / week* / month / quarter – snowflake documentation, 6ear* / day* / week* / month / quarter – snowflake documentation, ywar* / day* / week* / month / quarter – snowflake documentation, ysar* / day* / week* / month / quarter – snowflake documentation, ydar* / day* / week* / month / quarter – snowflake documentation, yrar* / day* / week* / month / quarter – snowflake documentation, y4ar* / day* / week* / month / quarter – snowflake documentation, y3ar* / day* / week* / month / quarter – snowflake documentation, yezr* / day* / week* / month / quarter – snowflake documentation, yesr* / day* / week* / month / quarter – snowflake documentation, yewr* / day* / week* / month / quarter – snowflake documentation, yeqr* / day* / week* / month / quarter – snowflake documentation, yeae* / day* / week* / month / quarter – snowflake documentation, yead* / day* / week* / month / quarter – snowflake documentation, yeaf* / day* / week* / month / quarter – snowflake documentation, yeat* / day* / week* / month / quarter – snowflake documentation, yea5* / day* / week* / month / quarter – snowflake documentation, yea4* / day* / week* / month / quarter – snowflake documentation, year* / say* / week* / month / quarter – snowflake documentation, year* / xay* / week* / month / quarter – snowflake documentation, year* / cay* / week* / month / quarter – snowflake documentation, year* / fay* / week* / month / quarter – snowflake documentation, year* / ray* / week* / month / quarter – snowflake documentation, year* / eay* / week* / month / quarter – snowflake documentation, year* / dzy* / week* / month / quarter – snowflake documentation, year* / dsy* / week* / month / quarter – snowflake documentation, year* / dwy* / week* / month / quarter – snowflake documentation, year* / dqy* / week* / month / quarter – snowflake documentation, year* / dat* / week* / month / quarter – snowflake documentation, year* / dag* / week* / month / quarter – snowflake documentation, year* / dah* / week* / month / quarter – snowflake documentation, year* / dau* / week* / month / quarter – snowflake documentation, year* / da7* / week* / month / quarter – snowflake documentation, year* / da6* / week* / month / quarter – snowflake documentation, year* / day* / qeek* / month / quarter – snowflake documentation, year* / day* / aeek* / month / quarter – snowflake documentation, year* / day* / seek* / month / quarter – snowflake documentation, year* / day* / eeek* / month / quarter – snowflake documentation, year* / day* / 3eek* / month / quarter – snowflake documentation, year* / day* / 2eek* / month / quarter – snowflake documentation, year* / day* / wwek* / month / quarter – snowflake documentation, year* / day* / wsek* / month / quarter – snowflake documentation, year* / day* / wdek* / month / quarter – snowflake documentation, year* / day* / wrek* / month / quarter – snowflake documentation, year* / day* / w4ek* / month / quarter – snowflake documentation, year* / day* / w3ek* / month / quarter – snowflake documentation, year* / day* / wewk* / month / quarter – snowflake documentation, year* / day* / wesk* / month / quarter – snowflake documentation, year* / day* / wedk* / month / quarter – snowflake documentation, year* / day* / werk* / month / quarter – snowflake documentation, year* / day* / we4k* / month / quarter – snowflake documentation, year* / day* / we3k* / month / quarter – snowflake documentation, year* / day* / weej* / month / quarter – snowflake documentation, year* / day* / weem* / month / quarter – snowflake documentation, year* / day* / weel* / month / quarter – snowflake documentation, year* / day* / weeo* / month / quarter – snowflake documentation, year* / day* / weei* / month / quarter – snowflake documentation, year* / day* / week* / nonth / quarter – snowflake documentation, year* / day* / week* / konth / quarter – snowflake documentation, year* / day* / week* / jonth / quarter – snowflake documentation, year* / day* / week* / minth / quarter – snowflake documentation, year* / day* / week* / mknth / quarter – snowflake documentation, year* / day* / week* / mlnth / quarter – snowflake documentation, year* / day* / week* / mpnth / quarter – snowflake documentation, year* / day* / week* / m0nth / quarter – snowflake documentation, year* / day* / week* / m9nth / quarter – snowflake documentation, year* / day* / week* / mobth / quarter – snowflake documentation, year* / day* / week* / momth / quarter – snowflake documentation, year* / day* / week* / mojth / quarter – snowflake documentation, year* / day* / week* / mohth / quarter – snowflake documentation, year* / day* / week* / monrh / quarter – snowflake documentation, year* / day* / week* / monfh / quarter – snowflake documentation, year* / day* / week* / mongh / quarter – snowflake documentation, year* / day* / week* / monyh / quarter – snowflake documentation, year* / day* / week* / mon6h / quarter – snowflake documentation, year* / day* / week* / mon5h / quarter – snowflake documentation, year* / day* / week* / montg / quarter – snowflake documentation, year* / day* / week* / montb / quarter – snowflake documentation, year* / day* / week* / montn / quarter – snowflake documentation, year* / day* / week* / montj / quarter – snowflake documentation, year* / day* / week* / montu / quarter – snowflake documentation, year* / day* / week* / monty / quarter – snowflake documentation, year* / day* / week* / month / 1uarter – snowflake documentation, year* / day* / week* / month / 2uarter – snowflake documentation, year* / day* / week* / month / wuarter – snowflake documentation, year* / day* / week* / month / auarter – snowflake documentation, year* / day* / week* / month / qyarter – snowflake documentation, year* / day* / week* / month / qharter – snowflake documentation, year* / day* / week* / month / qjarter – snowflake documentation, year* / day* / week* / month / qiarter – snowflake documentation, year* / day* / week* / month / q8arter – snowflake documentation, year* / day* / week* / month / q7arter – snowflake documentation, year* / day* / week* / month / quzrter – snowflake documentation, year* / day* / week* / month / qusrter – snowflake documentation, year* / day* / week* / month / quwrter – snowflake documentation, year* / day* / week* / month / quqrter – snowflake documentation, year* / day* / week* / month / quaeter – snowflake documentation, year* / day* / week* / month / quadter – snowflake documentation, year* / day* / week* / month / quafter – snowflake documentation, year* / day* / week* / month / quatter – snowflake documentation, year* / day* / week* / month / qua5ter – snowflake documentation, year* / day* / week* / month / qua4ter – snowflake documentation, year* / day* / week* / month / quarrer – snowflake documentation, year* / day* / week* / month / quarfer – snowflake documentation, year* / day* / week* / month / quarger – snowflake documentation, year* / day* / week* / month / quaryer – snowflake documentation, year* / day* / week* / month / quar6er – snowflake documentation, year* / day* / week* / month / quar5er – snowflake documentation, year* / day* / week* / month / quartwr – snowflake documentation, year* / day* / week* / month / quartsr – snowflake documentation, year* / day* / week* / month / quartdr – snowflake documentation, year* / day* / week* / month / quartrr – snowflake documentation, year* / day* / week* / month / quart4r – snowflake documentation, year* / day* / week* / month / quart3r – snowflake documentation, year* / day* / week* / month / quartee – snowflake documentation, year* / day* / week* / month / quarted – snowflake documentation