Brian Aker wrote:
Hi!

On Feb 4, 2009, at 2:07 AM, Jay Pipes wrote:

I would actually argue that DATE_FORMAT() is the function that is overly complex...

Agreed.

I use the hell out of this function :)

Which one? DATE_FORMAT()? Nothing is changing about DATE_FORMAT() other than internally using mktime() and strftime() instead of the custom code currently in the server. The behaviour of DATE_FORMAT() will be identical to MySQL, with the exception that all invalid temporal values will trigger an error in Drizzle.

Though, I have told people over and over again to put this sort of thing up in their display logic and get it out of their SQL.

The problem has been that there have been few/fast date manipulation libraries available (especially in perl). So you fall back to using the database to do the heavy lifting for you.

Agreed, though getting much better in almost all languages I know.

-jay

_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to     : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help   : https://help.launchpad.net/ListHelp

Reply via email to