The Vertica Database Forums

Posted: **Tue Nov 22, 2016 7:43 pm**

I need to calculate the count of slots for each hour like 2016-01-01 00:00:00,2016-01-01 01:00:00,..........

I tried using below query but it did not worked,please suggest

Code: Select all

SELECT count(slots) FROM acctn 
WHERE  (DATEPART(mm, start_time) = 00 AND (DATEPART(ss, start_time) = 00

output should be like:

Date   					count
 2016-01-01 00:00:00			value
 2016-01-01 01:00:00			value

Posted: **Tue Nov 22, 2016 9:50 pm**

This is one way:

Code: Select all

select count(slots) as slots_cnt,
       to_char(start_time, 'DD-MON-YYYY HH24') as date_hr
  from acctn
 group by 2
 order by 2;

The Vertica Database Forums

how to use the datepart function to calculate the count at specific time?

how to use the datepart function to calculate the count at specific time?

Re: how to use the datepart function to calculate the count at specific time?