At 34:25, if you type SELECT CAST(DATE('2024-08-28') AS int) in mysql, it returns 20240828, which is a decimal representation of the date. 20240828-20240101=727. So, my guess is that dates are coerced to int before substracting them.
28:37 is wrong - select now() works in duckdb - now() is documented in Timestamp with Time Zone Functions - syntax error at or near "" suggests duckdb repl was messed up from previous error
![ปฏิเสธไม่ไหว (Crush on you) - LIPTA feat. No One Else [TEASER MV]](http://i.ytimg.com/vi/VC689EgdSIw/mqdefault.jpg)
![[Live] : ONE 169 วันนี้!! "อนาโตลี vs อูมาร์"](http://i.ytimg.com/vi/IK3YZVWuFJg/mqdefault.jpg)
Love the presentation style!
At 34:25, if you type SELECT CAST(DATE('2024-08-28') AS int) in mysql, it returns 20240828, which is a decimal representation of the date. 20240828-20240101=727. So, my guess is that dates are coerced to int before substracting them.
CMU Database Group, wanna collab it was really entertaining
Amazing! Thank u
Intro makes me wanna enroll
really nice course, good presentation skills
Notes link in the description is broken
What Google paper is he talking about at 6:42 ?
“SQL Has Problems. We Can Fix Them: Pipe Syntax In SQL“ 2024
that intro is fire🔥🔥🔥
Does anyone know which CLI interface Pavlo is using in the prompt?
SmarTTY
The link to the Notes section is not working.
the thumbnail tells me most of this class refers to women as 'females' 👍
28:37 is wrong - select now() works in duckdb - now() is documented in Timestamp with Time Zone Functions - syntax error at or near "" suggests duckdb repl was messed up from previous error