* Anders Bjarby > Jag har problem med en enkel SELECT DISTINCT, på ett enda fält i en enda > tabell. Har jag missat något mycket grundläggande eller är det en BUG?
I would suggest you use english on this list... :) <cut> > | indate | timestamp(8) | YES | | NULL | | I think your problem is the data type... timestamp is a special field type, used for automatic storing of the current time for inserts and updates. I think the entire timestamp is stored in the column, even if you have defined it as timestamp(8). (Only the display width of the column is restricted by (8).) Try changing it to a DATE field. -- Roger database, table --------------------------------------------------------------------- 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
