ansaurus

Question

Answer 1

+6 A:

I don't have a database to test with, but it seems like you are looking for

select
  substr(timestamp, 1, 8),
  count(*)
from
  my_table
group by
  substr(timestamp, 1, 8);

Brandon Horsley 2010-08-19 23:43:10

I think that might do the trick. Thank you very much. I was trying to do substring() as YMD and then group by YMD.

krick 2010-08-20 00:12:55

Answer 2

A:

Thank you very much.

Kashan Ahmad 2010-10-19 13:38:46

Oracle SQL query count group by timestamp substring