On Wed, Jan 14, 2009 at 06:37:50PM -0500, Jay Pipes wrote: > I would like to change the above behaviour to throw an error when a > string is tranformed using the format string argument and the resulting > DATE, TIME, or DATETIME is not valid.
+1 > Any problems with this? > > Also, what should the following return? > > SELECT STR_TO_DATE(NULL, '%Y-%m-%d'); > > SELECT STR_TO_DATE(NULL, NULL); > > MySQL returns a NULL value with no warning for both examples: I think this is correct behaviour. along the thought lines of "doing something on nothing will only get you nothing". -- Stewart Smith _______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
