sql - MySQL: hourly average value -


I have a 'timestamp' column and a 'value' column where the value is approximately 3 seconds. / P>

I am trying to return a table whose daily average value is

So, there is something I'm looking for.

  | Timestamp | Average | | 2010-06-02 | 456.6 | | 2010-06-03 | 58 9.4 | | 2010-06-04 | 268.5 | Etc ...  

Any help on this will be highly appreciated. DATE (timestamp) by the table group from

  SELECT DATE (timestamp), AGG (value)  

Since you want days instead of every timestamp


Comments

Popular posts from this blog

c# - sqlDecimal to decimal clr stored procedure Unable to cast object of type 'System.Data.SqlTypes.SqlDecimal' to type 'System.IConvertible' -

Calling GetGUIThreadInfo from Outlook VBA -

Obfuscating Python code? -