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 ?
No, it puts it into some four bytes, not in plain text format. The
output of it looks like as you described.
Any format can be used. For other things look into manual:
http://mysql.mirror.ok.ee/Manual_chapter/manual_Reference.html#Date_and_time_functions
You anyway need it.
--
+----------------------------------------------------------------+
| TcX ____ __ _____ _____ ___ |
| /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Tõnu Samuel |
| /*/ /*/ /*/ \*\_ |*| |*||*| tonu@stripped |
| /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Tallinn, Estonia |
| /*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____ |
| ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^ |
| /*/ \*\ Developers Team |
+----------------------------------------------------------------+
