$minute (Get Minute)
Last updated: 2026-10-09
$minute (Get Minute)
$minute returns the minute part of a date (0 to 59) — common for minute-granularity traffic stats, monitoring metrics, or window labels. It returns an integer without zero padding. timezone can shift which minute a timestamp belongs to: zones with minute offsets (e.g. UTC+5:45) produce different values, so always set it explicitly. Combine with $hour and $second to rebuild full times.
| Category | Date |
|---|---|
| MongoDB Version | 1.0+ |
| Example Language | mongosh (Shell) |
📝 Syntax
{ $minute: { date: <date-expression>, timezone: <timezone> } }⚙️ Parameters
| date | Required; the date expression. |
|---|---|
| timezone | Optional timezone; defaults to UTC. |
Returns：The minute (0-59); null if date is null.
▶ Example
Run the commands below in your local mongosh (requires a running mongod):
// $minute: log volume by hour-minute (Beijing time)
db.logs.aggregate([
{ $group: {
_id: { h: { $hour: { date: '$ts', timezone: 'Asia/Shanghai' } }, m: { $minute: { date: '$ts', timezone: 'Asia/Shanghai' } } },
cnt: { $sum: 1 }
} }
])Output：
{ "_id": { "h": 8, "m": 30 }, "cnt": 56 }
{ "_id": { "h": 8, "m": 31 }, "cnt": 48 }📌 Notes
- Range 0-59, wrapping at 60
- Zones with minute offsets (e.g. UTC+5:45) change the minute value after conversion
- Results shift across zones — unify timezone before stats
🏷️ Related Tags
💡 Related Cases
More hands-on cases coming soon.
📚 Related Tutorials
❓ FAQ
QWhat is the range?
A0 to 59.
QDoes timezone affect the minute?
AYes — zones with minute offsets (like +5:45) yield different values.
QHow to get a two-digit minute string?
AUse the %M placeholder of $dateToString for two digits.
