On Mon, 27 Aug 2001, Betto McRose G, wrote:

> I want to know if it's possible to put a "format" to a Date Field into the
> DB. For example: I have a data only JUN/2001 for a table, but the field
> FechaINI format is 0000-00-00, so I want to put just 0000-00 but I cannot.

Let MySQL store its format. When you retrieve a date field you may get
exactly what you want using the DATE_FORMAT(date,format) function.

Thomas


---------------------------------------------------------------------
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

Reply via email to