Grouping by day with unix timestamp

[hessodreamy]

Times in my database are stored as unix timestamps, and I need to find out how many sales per day. How do I use mysql to group by day when working with unix timestamps? I thought i could use something like select yea(timestamp) .... but this returns null.
Can anyone help?

 

[r937]

select from_unixtime(timestampcol,"%Y-%m-%d") 
                     as theday
     , sum(salesamt) as total_sales
  from yourtable
group
    by from_unixtime(timestampcol,"%Y-%m-%d")

rudy | r937.com | Ask the Expert | Premium SQL Articles
SQL for Database-Driven Web Sites (next course starts May 8 2005)

 

[hessodreamy]

Yes that works great. Thanks.