$year (Get Year)

Last updated: 2026-10-09

$year (Get Year)

$year returns the full year of a date (e.g. 2026) — the most basic date extractor. It often combines with $month or $week into multi-level group keys, or serves yearly archiving and year-over-year analysis. Returns an integer. Note the difference from $isoWeekYear, which returns the ISO week's year and can differ in straddling weeks — prefer it for week-based stats.

CategoryDate
MongoDB Version1.0+
Example Languagemongosh (Shell)

📝 Syntax

{ $year: { date: <date-expression>, timezone: <timezone> } }

⚙️ Parameters

dateRequired; the date expression.
timezoneOptional timezone; defaults to UTC.

Returns:The year as an integer; null if date is null.

▶ Example

Run the commands below in your local mongosh (requires a running mongod):

// $year: order totals by year
 db.orders.aggregate([
  { $group: {
      _id: { $year: { date: '$orderDate' } },
      total: { $sum: '$amount' }
  } }
])

Output:

{ "_id": 2026, "total": 892000 }
{ "_id": 2025, "total": 764000 }

📌 Notes

More hands-on cases coming soon.

📚 Related Tutorials

❓ FAQ

QHow many digits is the year?
AFour digits, e.g. 2026.
QWhen does it differ from $isoWeekYear?
AIn ISO straddling weeks around New Year, the years can differ by 1.
QCan it be used for yearly archiving?
AYes — filter or group by $year with $match or $group.
Web-Tutorial.com

Web-Tutorial Tech Team

A team of developers maintaining programming tutorials. Each tutorial is written and reviewed by developers with expertise in that field. We work to keep our content accurate and reliable — if you spot an issue, please let us know.

100%

🙏 帮我们做得更好

我们是刚上线的编程教程站,几个人的小团队,精力有限。页面虽经检查,难免还有疏漏——链接失效、排版错乱、内容有误、语言生硬……

如果您发现了,麻烦告诉我们,我们会在收到反馈后第一时间进行修复,再次感谢您的光临 🙏