Hi! On Thu, Jan 15, 2009 at 1:41 PM, Roy Lyseng <[email protected]> wrote: >>> My stance for STR_TO_DATE(NULL,NULL); is that you can immediately see >>> that the format string is invalid. Therefore, it should give an error. > > Not entirely correct, unless I have misinterpreted you. > > The format string can be an expression, e.g a column reference. In this case > you rely on a runtime check to see whether the format expression is valid.
Right. But then the example should have read: STR_TO_DATE(NULL, <expr>) * Did I ever mention I take things pretty literally? :) > > But I still agree that any invalid format string should cause an > exception... No kidding - you are right of course - I did not consider the possibility that the NULL was meant as notation of the value - I though the NULL keyword was meant as is...my blind spot. > > Thanks, > Roy >> >> I sit convinced. >> >> /me stands up. >> >> now i stand convinced >> >> :) > -- Roland Bouman http://rpbouman.blogspot.com/ _______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
