Extracting Date & Hour in Vertica Table

RK001

Hi All,

 

I want to extract date & hour from the below table structure i.e. 23-07-2015 and 06:00 hrs. I was trying with Date_Part but was not able to get the required result.

 

Table Structure

 

           created_at           | count
--------------------------------+-------
 Thu Jul 23 00:00:14 +0000 2015 |     1
 Thu Jul 23 00:00:20 +0000 2015 |     1
 Thu Jul 23 00:00:39 +0000 2015 |     1
 Thu Jul 23 00:01:07 +0000 2015 |     1
 Thu Jul 23 00:03:00 +0000 2015 |     1
 Thu Jul 23 00:04:28 +0000 2015 |     1
 Thu Jul 23 00:04:35 +0000 2015 |     1
 Thu Jul 23 00:04:41 +0000 2015 |     1

 

Please guide!

 

Best Regards

RK

 

NorbertK

What is the data type for your created_at column?