MySQL Forums
Forum List  »  InnoDB

want resultset grouped by month have only datetime type
Posted by: kanchan thukral
Date: July 22, 2005 02:46AM

actually i'm using datetime data type in mysql and i want to run the query which return grouped by month resultset

i'm running this querry

select * from alarmlog group by (select month('alarmlog.creationtime'))

here creationtime is datetime datatype.actually month is returning null value.
so the whole table is grouping in only one resultset as month is null

so please tell me.

Options: ReplyQuote


Subject
Views
Written By
Posted
want resultset grouped by month have only datetime type
2898
July 22, 2005 02:46AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.