Intermediate SQL
Date & Time SQL Lessons
Learn EXTRACT, DATE_TRUNC, INTERVAL, YTD/MTD through focused tutorials and business-data examples.
Lessons in this category
SQL Dates and TimeRead lesson SQL CURRENT_DATERead lesson SQL CURRENT_TIMERead lesson SQL CURRENT_TIMESTAMPRead lesson SQL NOWRead lesson SQL EXTRACTRead lesson SQL Extract YearRead lesson SQL Extract QuarterRead lesson SQL Extract MonthRead lesson SQL Extract WeekRead lesson SQL Extract DayRead lesson SQL Extract Day of WeekRead lesson SQL Extract HourRead lesson SQL DATE_PARTRead lesson SQL DATE_TRUNCRead lesson SQL DATE_TRUNC by YearRead lesson SQL DATE_TRUNC by QuarterRead lesson SQL DATE_TRUNC by MonthRead lesson SQL DATE_TRUNC by WeekRead lesson SQL Date ArithmeticRead lesson SQL INTERVALRead lesson SQL Add Days to a DateRead lesson SQL Subtract Days from a DateRead lesson SQL Add Months to a DateRead lesson SQL Subtract DatesRead lesson SQL AGERead lesson SQL TO_DATERead lesson SQL TO_TIMESTAMPRead lesson SQL TO_CHARRead lesson SQL Date FormattingRead lesson SQL Timestamp to DateRead lesson SQL Filtering the Last 7 DaysRead lesson SQL Filtering the Last 30 DaysRead lesson SQL Current MonthRead lesson SQL Previous MonthRead lesson SQL Current QuarterRead lesson SQL Current YearRead lesson SQL Year-to-DateRead lesson SQL Month-to-DateRead lesson SQL Days Between DatesRead lesson SQL Days Since SignupRead lesson SQL Time Between EventsRead lesson