Options

interval or TIMESTAMPADD()

mesunderlinmesunderlin
in General Discussion

Looking to query vertica for records where a timestamp column's value is more than 6 hours older than the current time.  Is there any significant advantage of one of these over the other:

 


 <= (TIMESTAMPADD(HOUR,-6,CURRENT_TIMESTAMP))::timestamptz

 

 <= (current_timestamp - interval '6 hours')

 

 

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...