DCCoolBreeze
asked on
MYSQL: Extract Date from Timestamp Field
I have a table that has only two fields: dtmDateTime timestamp field; fData float field. I want to group data by max, min, avg by date. How can I do this via SQL SELECT. I tried select convert(varchar,dtmdatetim e,104) from tablename; but it does not work - error is returned for convert. Any help extracting the date from the timestamp field would be appreciated
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.