The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

Extracting Date & Hour in Vertica Table

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

 

Comments

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.