Bug #33962 Need GLOBAL and SESSION Modes to control datetime output format

• Submitted: 21 Jan 2008 17:44
• Modified: 28 Jan 2008 16:48
• Reporter: Jeff Armstrong
• Status: Won't fix
• Category: MySQL Server
• Severity: S4 (Feature request)
• Version: Any
• OS: Any
• CPU Architecture: Any
• Tags: datetime, output format

[21 Jan 2008 17:44] Jeff Armstrong

Description:
All our standard datetime routines expect datetime values to be presented in ISO long format e.g. YYMMDDHHMMSS. We find ourselves constantly post-processing MySQL every result set to strip out the carefully added punctuation on all datetime columns.

May we please, please have a global / session setting where we might specify a datetime output format. In our case, we would want the format above. I can imagine other formats would be appropriate elsewhere.

Many thanks,

J Armstrong,
London, UK

How to repeat:
Feature request

Suggested fix:
Feature request

[28 Jan 2008 16:48] Susanne Ebrecht

Many thanks for writing a feature request.

The format of your wish is not at the SQL standard.

You can use the function DATE_FORMAT() to get every date and time form you wish to get.

Look:
http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html