Issue while using special characters like single cote on date in procedures

1

While executing the procedure on Postgres server having single cote on date pattern causing below error.

ERROR: Exception Primary Reason: ERROR: syntax error at or near “YYYY”

Actual : to_timestamp(datetime,‘YYYY-MM-DD HH24:MI:SS’),
to_timestamp(timestamp,‘YYYY-MM-DD HH24:MI:SS’),

when i tried to update single cote to double cotes after that execution of procedure works fine. when i insert some data getting below error because it should be in single cote like ,‘YYYY-MM-DD HH24:MI:SS’

ERROR: column “YYYY-MM-DD HH24:MI:SS” does not exist
LINE 27: to_timestamp(datetime,“YYYY-MM-DD HH24:MI:SS”),
^

2

Hi @subbum,

I think this issue is happening because we need to override the method public String getDateLiteral(final String isoDate) for Postgres database. I’m pretty sure by doing that the issue you are facing should not keep happening.

Are you keen to submit a PR with this change? If you are feel free to create one or ask any other question you have.

Thanks in advance,
Daniel.