I have a database that I am using an ODBC connection to connect to. I can connect to it and pull data. Now i am doing some data modeling and trying to reduce the amount of data and runtime via applying a where clause on a date field. The date field is in epoch time. I would like to set a variable to convert the epoch time to regular time in the script so if I have to use it again, I can simply refer to the variable name. I have the script below, but it returns 'Not a valid month', ORA-01843 . I have tried several variations such as
$(SubmitDate) > '01/01/2013'
$(SubmitDate) > '01/01/2013 12:00:00'
$(SubmitDate) > '01/01/2013 12:00:00 AM'
No dice. Could someone help me out with syntax here?