Vertica DB: Need to use a date string and convert as part of where clause

Question

I have a field in vertica

deviceReceiptTime   -5  Integer 19  8

It appears to hold milliseconds

1504828819089
1504828819071

Epoch date  Human readable date (GMT) 
1504828819  2017-09-08 00:00:19

I would like the analyst to be able to enter a standard date format like YYYY-MMDD HH24MISS instead of converting to milliseconds first.

instead of

where deviceReceiptTime Between 1490270439780 and 1490270448888

Answer 1

Maybe something like this...

where deviceReceiptTime between 
    extract ( epoch from <lower_limit ) and 
    extract ( epoch from <higher_limit> )

For example:

where deviceReceiptTime between 
    extract ( epoch from '2017-02-08 00:00:00'::timestamp ) and 
    extract ( epoch from '2017-04-08 00:00:00'::timestamp )