Hi All those responded! Thanks Thomas Spahni and Jan. First thing fisrt. I did see the manual doc pages (a lot) when I was trying the date_format function. Once I could not succeed (and could not understood the docs) I posted my question. Now the point is that date_format is not really for formatting the *input* date into the MySQL but for formatting the date for *output*. Thanks all those responded. But just wondering as why the INSERT command silently takes date_format(xxx, xxx) stuff.
Thanks & Regards ----- Original Message ----- From: "Thomas Spahni" <[EMAIL PROTECTED]> To: "R.C.Nougain" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, June 04, 2002 7:23 PM Subject: Re: Problem in inserting date > 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
