Uncategorized

QUARTER – Snowflake Documentation

October 13, 2025

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.

https://docs.snowflake.com/en/sql-reference/functions/year

YEAR* / DAY* / WEEK* / MONTH / QUARTER – Snowflake Documentation <body> <h1> Array ( [0] => tear* / day* / week* / month / quarter – snowflake documentation [1] => gear* / day* / week* / month / quarter – snowflake documentation [2] => hear* / day* / week* / month / quarter – snowflake documentation [3] => uear* / day* / week* / month / quarter – snowflake documentation [4] => 7ear* / day* / week* / month / quarter – snowflake documentation [5] => 6ear* / day* / week* / month / quarter – snowflake documentation [6] => ywar* / day* / week* / month / quarter – snowflake documentation [7] => ysar* / day* / week* / month / quarter – snowflake documentation [8] => ydar* / day* / week* / month / quarter – snowflake documentation [9] => yrar* / day* / week* / month / quarter – snowflake documentation [10] => y4ar* / day* / week* / month / quarter – snowflake documentation [11] => y3ar* / day* / week* / month / quarter – snowflake documentation [12] => yezr* / day* / week* / month / quarter – snowflake documentation [13] => yesr* / day* / week* / month / quarter – snowflake documentation [14] => yewr* / day* / week* / month / quarter – snowflake documentation [15] => yeqr* / day* / week* / month / quarter – snowflake documentation [16] => yeae* / day* / week* / month / quarter – snowflake documentation [17] => yead* / day* / week* / month / quarter – snowflake documentation [18] => yeaf* / day* / week* / month / quarter – snowflake documentation [19] => yeat* / day* / week* / month / quarter – snowflake documentation [20] => yea5* / day* / week* / month / quarter – snowflake documentation [21] => yea4* / day* / week* / month / quarter – snowflake documentation [22] => year* / say* / week* / month / quarter – snowflake documentation [23] => year* / xay* / week* / month / quarter – snowflake documentation [24] => year* / cay* / week* / month / quarter – snowflake documentation [25] => year* / fay* / week* / month / quarter – snowflake documentation [26] => year* / ray* / week* / month / quarter – snowflake documentation [27] => year* / eay* / week* / month / quarter – snowflake documentation [28] => year* / dzy* / week* / month / quarter – snowflake documentation [29] => year* / dsy* / week* / month / quarter – snowflake documentation [30] => year* / dwy* / week* / month / quarter – snowflake documentation [31] => year* / dqy* / week* / month / quarter – snowflake documentation [32] => year* / dat* / week* / month / quarter – snowflake documentation [33] => year* / dag* / week* / month / quarter – snowflake documentation [34] => year* / dah* / week* / month / quarter – snowflake documentation [35] => year* / dau* / week* / month / quarter – snowflake documentation [36] => year* / da7* / week* / month / quarter – snowflake documentation [37] => year* / da6* / week* / month / quarter – snowflake documentation [38] => year* / day* / qeek* / month / quarter – snowflake documentation [39] => year* / day* / aeek* / month / quarter – snowflake documentation [40] => year* / day* / seek* / month / quarter – snowflake documentation [41] => year* / day* / eeek* / month / quarter – snowflake documentation [42] => year* / day* / 3eek* / month / quarter – snowflake documentation [43] => year* / day* / 2eek* / month / quarter – snowflake documentation [44] => year* / day* / wwek* / month / quarter – snowflake documentation [45] => year* / day* / wsek* / month / quarter – snowflake documentation [46] => year* / day* / wdek* / month / quarter – snowflake documentation [47] => year* / day* / wrek* / month / quarter – snowflake documentation [48] => year* / day* / w4ek* / month / quarter – snowflake documentation [49] => year* / day* / w3ek* / month / quarter – snowflake documentation [50] => year* / day* / wewk* / month / quarter – snowflake documentation [51] => year* / day* / wesk* / month / quarter – snowflake documentation [52] => year* / day* / wedk* / month / quarter – snowflake documentation [53] => year* / day* / werk* / month / quarter – snowflake documentation [54] => year* / day* / we4k* / month / quarter – snowflake documentation [55] => year* / day* / we3k* / month / quarter – snowflake documentation [56] => year* / day* / weej* / month / quarter – snowflake documentation [57] => year* / day* / weem* / month / quarter – snowflake documentation [58] => year* / day* / weel* / month / quarter – snowflake documentation [59] => year* / day* / weeo* / month / quarter – snowflake documentation [60] => year* / day* / weei* / month / quarter – snowflake documentation [61] => year* / day* / week* / nonth / quarter – snowflake documentation [62] => year* / day* / week* / konth / quarter – snowflake documentation [63] => year* / day* / week* / jonth / quarter – snowflake documentation [64] => year* / day* / week* / jonth / quarter – snowflake documentation [65] => year* / day* / week* / minth / quarter – snowflake documentation [66] => year* / day* / week* / mknth / quarter – snowflake documentation [67] => year* / day* / week* / mlnth / quarter – snowflake documentation [68] => year* / day* / week* / mpnth / quarter – snowflake documentation [69] => year* / day* / week* / m0nth / quarter – snowflake documentation [70] => year* / day* / week* / m9nth / quarter – snowflake documentation [71] => year* / day* / week* / mobth / quarter – snowflake documentation [72] => year* / day* / week* / momth / quarter – snowflake documentation [73] => year* / day* / week* / mojth / quarter – snowflake documentation [74] => year* / day* / week* / mohth / quarter – snowflake documentation [75] => year* / day* / week* / mohth / quarter – snowflake documentation [76] => year* / day* / week* / monrh / quarter – snowflake documentation [77] => year* / day* / week* / monfh / quarter – snowflake documentation [78] => year* / day* / week* / mongh / quarter – snowflake documentation [79] => year* / day* / week* / monyh / quarter – snowflake documentation [80] => year* / day* / week* / mon6h / quarter – snowflake documentation [81] => year* / day* / week* / mon5h / quarter – snowflake documentation [82] => year* / day* / week* / montg / quarter – snowflake documentation [83] => year* / day* / week* / montb / quarter – snowflake documentation [84] => year* / day* / week* / montn / quarter – snowflake documentation [85] => year* / day* / week* / montj / quarter – snowflake documentation [86] => year* / day* / week* / montu / quarter – snowflake documentation [87] => year* / day* / week* / monty / quarter – snowflake documentation [88] => year* / day* / week* / month / 1uarter – snowflake documentation [89] => year* / day* / week* / month / 2uarter – snowflake documentation [90] => year* / day* / week* / month / wuarter – snowflake documentation [91] => year* / day* / week* / month / auarter – snowflake documentation [92] => year* / day* / week* / month / qyarter – snowflake documentation [93] => year* / day* / week* / month / qharter – snowflake documentation [94] => year* / day* / week* / month / qjarter – snowflake documentation [95] => year* / day* / week* / month / qiarter – snowflake documentation [96] => year* / day* / week* / month / q8arter – snowflake documentation [97] => year* / day* / week* / month / q7arter – snowflake documentation [98] => year* / day* / week* / month / quzrter – snowflake documentation [99] => year* / day* / week* / month / qusrter – snowflake documentation [100] => year* / day* / week* / month / quwrter – snowflake documentation [101] => year* / day* / week* / month / quqrter – snowflake documentation [102] => year* / day* / week* / month / quaeter – snowflake documentation [103] => year* / day* / week* / month / quadter – snowflake documentation [104] => year* / day* / week* / month / quafter – snowflake documentation [105] => year* / day* / week* / month / quatter – snowflake documentation [106] => year* / day* / week* / month / qua5ter – snowflake documentation [107] => year* / day* / week* / month / qua4ter – snowflake documentation [108] => year* / day* / week* / month / quarrer – snowflake documentation [109] => year* / day* / week* / month / quarfer – snowflake documentation [110] => year* / day* / week* / month / quarger – snowflake documentation [111] => year* / day* / week* / month / quaryer – snowflake documentation [112] => year* / day* / week* / month / quar6er – snowflake documentation [113] => year* / day* / week* / month / quar5er – snowflake documentation [114] => year* / day* / week* / month / quartwr – snowflake documentation [115] => year* / day* / week* / month / quartsr – snowflake documentation [116] => year* / day* / week* / month / quartdr – snowflake documentation [117] => year* / day* / week* / month / quartrr – snowflake documentation [118] => year* / day* / week* / month / quart4r – snowflake documentation [119] => year* / day* / week* / month / quart3r – snowflake documentation [120] => year* / day* / week* / month / quartee – snowflake documentation [121] => year* / day* / week* / month / quarted – snowflake documentation [122] => year* / day* / week* / month / quartef – snowflake documentation [123] => year* / day* / week* / month / quartet – snowflake documentation [124] => year* / day* / week* / month / quarte5 – snowflake documentation [125] => year* / day* / week* / month / quarte4 – snowflake documentation [126] => year* / day* / week* / month / quarter ᰫ snowflake documentation [127] => year* / day* / week* / month / quarter &#u211; snowflake documentation [128] => year* / day* / week* / month / quarter &#i211; snowflake documentation [129] => year* / day* / week* / month / quarter ⏻ snowflake documentation [130] => year* / day* / week* / month / quarter ᾯ snowflake documentation [131] => year* / day* / week* / month / quarter &#8q11; snowflake documentation [132] => year* / day* / week* / month / quarter &#8w11; snowflake documentation [133] => year* / day* / week* / month / quarter ⁷ snowflake documentation [134] => year* / day* / week* / month / quarter ” snowflake documentation [135] => year* / day* / week* / month / quarter &#82q1; snowflake documentation [136] => year* / day* / week* / month / quarter — snowflake documentation [137] => year* / day* / week* / month / quarter &#821q; snowflake documentation [138] => year* / day* / week* / month / quarter &#8211l snowflake documentation [139] => year* / day* / week* / month / quarter &#8211p snowflake documentation [140] => year* / day* / week* / month / quarter &#8211. snowflake documentation [141] => year* / day* / week* / month / quarter – anowflake documentation [142] => year* / day* / week* / month / quarter – znowflake documentation [143] => year* / day* / week* / month / quarter – xnowflake documentation [144] => year* / day* / week* / month / quarter – dnowflake documentation [145] => year* / day* / week* / month / quarter – enowflake documentation [146] => year* / day* / week* / month / quarter – wnowflake documentation [147] => year* / day* / week* / month / quarter – sbowflake documentation [148] => year* / day* / week* / month / quarter – smowflake documentation [149] => year* / day* / week* / month / quarter – sjowflake documentation [150] => year* / day* / week* / month / quarter – showflake documentation [151] => year* / day* / week* / month / quarter – showflake documentation [152] => year* / day* / week* / month / quarter – sniwflake documentation [153] => year* / day* / week* / month / quarter – snkwflake documentation [154] => year* / day* / week* / month / quarter – snlwflake documentation [155] => year* / day* / week* / month / quarter – snpwflake documentation [156] => year* / day* / week* / month / quarter – sn0wflake documentation [157] => year* / day* / week* / month / quarter – sn9wflake documentation [158] => year* / day* / week* / month / quarter – snoqflake documentation [159] => year* / day* / week* / month / quarter – snoaflake documentation [160] => year* / day* / week* / month / quarter – snosflake documentation [161] => year* / day* / week* / month / quarter – snoeflake documentation [162] => year* / day* / week* / month / quarter – sno3flake documentation [163] => year* / day* / week* / month / quarter – sno2flake documentation [164] => year* / day* / week* / month / quarter – snowdlake documentation [165] => year* / day* / week* / month / quarter – snowclake documentation [166] => year* / day* / week* / month / quarter – snowvlake documentation [167] => year* / day* / week* / month / quarter – snowglake documentation [168] => year* / day* / week* / month / quarter – snowtlake documentation [169] => year* / day* / week* / month / quarter – snowrlake documentation [170] => year* / day* / week* / month / quarter – snowfkake documentation [171] => year* / day* / week* / month / quarter – snowfpake documentation [172] => year* / day* / week* / month / quarter – snowfoake documentation [173] => year* / day* / week* / month / quarter – snowflzke documentation [174] => year* / day* / week* / month / quarter – snowflske documentation [175] => year* / day* / week* / month / quarter – snowflwke documentation [176] => year* / day* / week* / month / quarter – snowflqke documentation [177] => year* / day* / week* / month / quarter – snowflaje documentation [178] => year* / day* / week* / month / quarter – snowflame documentation [179] => year* / day* / week* / month / quarter – snowflale documentation [180] => year* / day* / week* / month / quarter – snowflaoe documentation [181] => year* / day* / week* / month / quarter – snowflaie documentation [182] => year* / day* / week* / month / quarter – snowflakw documentation [183] => year* / day* / week* / month / quarter – snowflaks documentation [184] => year* / day* / week* / month / quarter – snowflakd documentation [185] => year* / day* / week* / month / quarter – snowflakr documentation [186] => year* / day* / week* / month / quarter – snowflak4 documentation [187] => year* / day* / week* / month / quarter – snowflak3 documentation [188] => year* / day* / week* / month / quarter – snowflake socumentation [189] => year* / day* / week* / month / quarter – snowflake xocumentation [190] => year* / day* / week* / month / quarter – snowflake cocumentation [191] => year* / day* / week* / month / quarter – snowflake focumentation [192] => year* / day* / week* / month / quarter – snowflake rocumentation [193] => year* / day* / week* / month / quarter – snowflake eocumentation [194] => year* / day* / week* / month / quarter – snowflake dicumentation [195] => year* / day* / week* / month / quarter – snowflake dkcumentation [196] => year* / day* / week* / month / quarter – snowflake dlcumentation [197] => year* / day* / week* / month / quarter – snowflake dpcumentation [198] => year* / day* / week* / month / quarter – snowflake d0cumentation [199] => year* / day* / week* / month / quarter – snowflake d9cumentation [200] => year* / day* / week* / month / quarter – snowflake doxumentation [201] => year* / day* / week* / month / quarter – snowflake dovumentation [202] => year* / day* / week* / month / quarter – snowflake dofumentation [203] => year* / day* / week* / month / quarter – snowflake dodumentation [204] => year* / day* / week* / month / quarter – snowflake dodumentation [205] => year* / day* / week* / month / quarter – snowflake docymentation [206] => year* / day* / week* / month / quarter – snowflake dochmentation [207] => year* / day* / week* / month / quarter – snowflake docjmentation [208] => year* / day* / week* / month / quarter – snowflake docimentation [209] => year* / day* / week* / month / quarter – snowflake doc8mentation [210] => year* / day* / week* / month / quarter – snowflake doc7mentation [211] => year* / day* / week* / month / quarter – snowflake docunentation [212] => year* / day* / week* / month / quarter – snowflake docukentation [213] => year* / day* / week* / month / quarter – snowflake docujentation [214] => year* / day* / week* / month / quarter – snowflake docujentation [215] => year* / day* / week* / month / quarter – snowflake documwntation [216] => year* / day* / week* / month / quarter – snowflake documsntation [217] => year* / day* / week* / month / quarter – snowflake documdntation [218] => year* / day* / week* / month / quarter – snowflake documrntation [219] => year* / day* / week* / month / quarter – snowflake docum4ntation [220] => year* / day* / week* / month / quarter – snowflake docum3ntation [221] => year* / day* / week* / month / quarter – snowflake documebtation [222] => year* / day* / week* / month / quarter – snowflake documemtation [223] => year* / day* / week* / month / quarter – snowflake documejtation [224] => year* / day* / week* / month / quarter – snowflake documehtation [225] => year* / day* / week* / month / quarter – snowflake documehtation [226] => year* / day* / week* / month / quarter – snowflake documenration [227] => year* / day* / week* / month / quarter – snowflake documenfation [228] => year* / day* / week* / month / quarter – snowflake documengation [229] => year* / day* / week* / month / quarter – snowflake documenyation [230] => year* / day* / week* / month / quarter – snowflake documen6ation [231] => year* / day* / week* / month / quarter – snowflake documen5ation [232] => year* / day* / week* / month / quarter – snowflake documentztion [233] => year* / day* / week* / month / quarter – snowflake documentstion [234] => year* / day* / week* / month / quarter – snowflake documentwtion [235] => year* / day* / week* / month / quarter – snowflake documentqtion [236] => year* / day* / week* / month / quarter – snowflake documentarion [237] => year* / day* / week* / month / quarter – snowflake documentafion [238] => year* / day* / week* / month / quarter – snowflake documentagion [239] => year* / day* / week* / month / quarter – snowflake documentayion [240] => year* / day* / week* / month / quarter – snowflake documenta6ion [241] => year* / day* / week* / month / quarter – snowflake documenta5ion [242] => year* / day* / week* / month / quarter – snowflake documentatuon [243] => year* / day* / week* / month / quarter – snowflake documentatjon [244] => year* / day* / week* / month / quarter – snowflake documentatkon [245] => year* / day* / week* / month / quarter – snowflake documentatoon [246] => year* / day* / week* / month / quarter – snowflake documentat9on [247] => year* / day* / week* / month / quarter – snowflake documentat8on [248] => year* / day* / week* / month / quarter – snowflake documentatiin [249] => year* / day* / week* / month / quarter – snowflake documentatikn [250] => year* / day* / week* / month / quarter – snowflake documentatiln [251] => year* / day* / week* / month / quarter – snowflake documentatipn [252] => year* / day* / week* / month / quarter – snowflake documentati0n [253] => year* / day* / week* / month / quarter – snowflake documentati9n [254] => year* / day* / week* / month / quarter – snowflake documentatiob [255] => year* / day* / week* / month / quarter – snowflake documentatiom [256] => year* / day* / week* / month / quarter – snowflake documentatioj [257] => year* / day* / week* / month / quarter – snowflake documentatioh [258] => year* / day* / week* / month / quarter – snowflake documentatioh ) </h1> </body>