SQL - YEAR(), MONTH(), DAY() Functions
Every non-trivial database application eventually needs to slice data by time. Monthly revenue reports, quarterly comparisons, year-over-year growth analysis—these all require breaking dates into…
Read more →Day
Pandas - Get Day of Week from Datetime
• Pandas provides multiple methods to extract day of week from datetime objects, including dt.dayofweek, dt.weekday(), and dt.day_name(), each serving different formatting needs
How to Use DAY in Excel
The DAY function is one of Excel’s fundamental date functions that extracts the day component from a date value. It returns an integer between 1 and 31, representing the day of the month. While…
Read more →