On Tue, 4 Jun 2002, R.C.Nougain wrote: > Bad answer. If you 'guess', then don't answer. The idea behind the > date_format is to format a date as per user's need and should not be forced > to a particular format just because some countries follows some format. > Still looking for serious answer?
RC, seriously, date_format determines the format of what you get out of this function, and not the format of the input. When you want to feed it a string, this string must be parsed and must be in a representation suitable to MySQL. By definition this is 'yyyy/mm/dd'. What you are looking for is a completely different function not yet available in MySQL. It would take a string, interprete it according to a given template and would then return the date in 'standard' representation. Thomas Spahni --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php