3 ms·
I'm not sure about comparing strings to numbers. But I know I appreciate it when I can query my database with: SELECT * FROM orders WHERE delivery_day b
by michaelt 4y ago
I'm not sure about comparing strings to numbers.
But I know I appreciate it when I can query my database with:
SELECT * FROM orders WHERE delivery_day
between '2023-04-10' and '2023-04-12'
Instead of using
SELECT * FROM orders WHERE delivery_day
between PARSE_DATE('%Y-%m-%d', '2023-04-10')
and PARSE_DATE('%Y-%m-%d', '2023-04-12')
So I can see why language designers put in some implicit conversions.
- jmalicki 4y agoThe difference is that it won't turn "abcjhd" into "1970-01-01", but rather issue an error.