What version of MySQL are you running? If you are on a version of 4.1 or higher, you have many more options than if you aren't.
(I would refer you to the online manual but it seems to be busy right now and I can't get to the URL I need.) Shawn Green Database Administrator Unimin Corporation - Spruce Pine Jerry Swanson <[EMAIL PROTECTED]> wrote on 10/26/2004 11:20:16 AM: > I have comlumn in mysql type datetime. I need to get the date in DATE format. > select DATE(reg_date) as test from a1; > > It gives me an error. > How to select date in different date format? > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] >