Propel icon indicating copy to clipboard operation
Propel copied to clipboard

Group by date from timestamp

Open imtiazPabel opened this issue 10 years ago • 3 comments

In my created_at field i keep timestamp value in table.Now i wanna execute a qurey to get group by as date from created_at field.I mean that i try to use mysql DATE().I tried different ways,can't do that.Is there any way?

imtiazPabel avatar Aug 04 '15 12:08 imtiazPabel

This sounds like a support question, and so the bug tracker is probably not the best place for it. I'd suggest Reddit or Stack Overflow. In either case it is probably worth showing what code you are working with.

halfer avatar Aug 14 '15 20:08 halfer

@halfer I suppose that their is no method for use DATE().That's why i wrote it in here

imtiazPabel avatar Aug 14 '15 20:08 imtiazPabel

Is this a feature request? Propel1 is in security fix updates only, as far as I know.

If you sure the question belongs here, it's worth showing what you are trying to do in more detail - perhaps by showing the SQL query that you're trying to build with the Query system.

halfer avatar Aug 14 '15 21:08 halfer