Working with Dates (SQL) - EXTRACT, DATE_PART, DATE_TRUNC, DATEDIFF
ฝัง
- เผยแพร่เมื่อ 14 ต.ค. 2024
- Working with dates in SQL can sometimes be a challenge! This video covers a few functions, which can help solve many of our issues with dates. The video covers EXTRACT, DATE_PART, DATE_TRUNC, and DATEDIFF.
wow, this video if very good.
This is a great video but DATEDIFF doesn't seem to be widely supported. It might be good to specify which SQL dialects support this function and alternate ways to address date differences when this is not supported!
You are the bomb. Omg
Thank you for the good content, The DATE_TRUNC should be like this; DATE_TRUNC('MONTH',timestamp) FROM orders
Like next level man
Bonjour svp j'aimerais que vous m'envoyez l'apk SQLite editor for Android j'aimerais plus l'étudier chez nous ici c'est payant et les cartes de crédit sont inaccessibles merci de plus sur votre clarification ❤
you did not cover the Date_part ??