On Tue, 26 Oct 1999, William Kerber wrote:
>Whenever I insert a date into a field by calling now(). It puts it in the
>Form yyyy-mm-dd . Is there any way I can get it to store in the format
>dd-mm-yyyy ?
>
>I am calling the database from PHP3.
>
>thanks for any help
>william
>
>
>
Yes, there is.
Please read a manual on date_format function. It allows all possible formating
of date/time output.
Sinisa
+----------------------------------------------------------------------+
| TcX ____ __ _____ _____ ___ == mysql@stripped |
| /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic |
| /*/ /*/ /*/ \*\_ |*| |*||*| mailto:sinisa@stripped|
| /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, Cyprus |
| /*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____ |
| ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^ |
| /*/ \*\ Developers Team |
+----------------------------------------------------------------------+
