RE: What's MYSQL equivalent to Oracle's TRUNC(date_time_var)?

2004-11-12 Thread Mike Johnson
From: sol beach [mailto:[EMAIL PROTECTED] 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

Re: What's MYSQL equivalent to Oracle's TRUNC(date_time_var)?

2004-11-12 Thread Bernard Clement
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