Mysql Update Getdate

DATE_FORMAT( date, format_mask) Parameter Values Parameter Description date Required. The date to format format_mask Required. The format to apply to date. Driver Update Software Downloads.

Free Download Golden Palominos Pure Rapidshare Programs Running on this page. I have a DATE column with dates in 2012-02-25 format. I need to update it to 12-02-25 but am not sure how to go about it? Edit: After reviewing all the answers, it seems I have not been clear enough. I do not wish to change my type, nor do I wish to play with the output. I want to update the existing date column from 2012 to 12. It should be an UPDATE query if anything, I'm just not sure how to write it. Thanks for all the comments so far.

Well organized and easy to understand Web building tutorials with lots of examples of how to use HTML, CSS, JavaScript, SQL, PHP, and XML.

Edit 2: It seems my question did not make sense, I was not aware you could not store DATE as xx-xx-xx. Thanks anyhow! From my: Date values with two-digit years are ambiguous because the century is unknown. Such values must be interpreted into four-digit form because MySQL stores years internally using four digits.

For DATETIME, DATE, and TIMESTAMP types, MySQL interprets dates specified with ambiguous year values using these rules: Year values in the range 00-69 are converted to 2000-2069. Year values in the range 70-99 are converted to 1970-1999. For YEAR, the rules are the same, with this exception: A numeric 00 inserted into YEAR(4) results in 0000 rather than 2000. To specify zero for YEAR(4) and have it be interpreted as 2000, specify it as a string '0' or '00'. Remember that these rules are only heuristics that provide reasonable guesses as to what your data values mean. If the rules used by MySQL do not produce the values you require, you must provide unambiguous input containing four-digit year values.