Look at the DATE() fucntion you can find in the REF Manual of MySQL at URL: http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html
Regards, Bernard On Friday 12 November 2004 12:14, sol beach wrote: > In Oracle TRUNC(data_time_var) returns only the date portion of a > date_time data type. > What's the easiest way in MYSQL to accomplish the same thing? > I tried to RTFM (Paul DuBios' MYSQL tome; 2nd Ed.), but no clean > solution lept out at me. > It is a GREAT book, but it did not help me in this case. > > TIA! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]