----- Original Message ----- From: "Jerry Swanson" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, October 26, 2004 11:20 AM Subject: date type & select
> 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? > RTFM? http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html Rhino -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]