IN-DB Date Filter Vertica Server

[cjsnets10]

I am attempting to do an IN-DB filter of 'date' > 2021-01-01.

I am connected to a Vertica server and have been unable to find the correct sql query.

[ShankerV]

Hi @cjsnets10 

1. There might be mismatch in the data type where you would have stored in VARCHAR[10] in database.

You need to convert into date format and apply the filter.

Shanker V

[cjsnets10]

@ShankerV would you be able to please provide how to do that IN-DB?

[apathetichell]

usually it's something like

`date` > '2021-01-01'

(or try)

"date" >= '2021-01-01'

basically your string value has to be in single quotes and your field name has to be standardized (double quotes usually works best). I do not use Vertica and I am not aware of any specific considerations for using datetime with it. - my assumption is that your field is stored as date or datetime - if not you'd need to cast it as date first using TO_DATE.