Re: Date format question

[Chris White]

Is it possible in mysql to create a date field that stores year and month
only (YYYY-MM) without having to zero out the day or use varchar type fields
Best here is to just use a DATE field, then use DATE_FORMAT when you 
want to pull up the customized date.  It will get stored as a timestamp 
(integer), so you really won't notice that much of a storage difference.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]