cfml

thoughts about a emptry string being passed as a date param without a sql type ending up as {ts '1900-01-01 00:00:00'} ?
<https://luceeserver.atlassian.net/browse/LDEV-2298?focusedCommentId=55031>

image.png

<https://trycf.com/gist/31f59a2fca2d23c53df10a00733d3558/lucee6-beta?theme=monokai>

&lt;cfscript&gt;
writedump(dateFormat(2,"yyyy-mm-dd"))
writedump(timeformat(2,"HH:MM:ss"))
&lt;/cfscript&gt;

I like it, as not everything should end up as SQL formatted, if a dev wants to add the Ts:{} let them.

Not a fan.  It should throw an error as it's invalid.

actually that's what sql server does <https://blog.sqlauthority.com/2021/05/06/sql-server-convert-empty-string-to-null-datetime/>

You are correct.  I'm not a fan of Microsoft's decision either.  I'm very opinionated on this and I'm of the opinion it should throw an error or be NULL. :man-shrugging::skin-tone-2:

if you set a sqltype for your params, it works fine

Should throw an error. Better would to set a default value for that field through the database engine.