Named Query :: DateTime not passing Time to query

Hi, I have a problem with the DateTime type in the named query not passing the time to the query (only date with no hours:min: sec).

In PostgreSQL, the stored procedure (routine) is using variables with timestamp types. I Logged the stored procedure’s input variables to a custom table to debug the thing. When calling the Stored Procedure from the query console in DataGrip (software), the whole DateTime is working well.

To workaround, I changed the datatype in the named query to text and the datatype in the stored procedure to text and then cast the string to the timestamp to get data between two dates.

Is there something I missed here to get DateTime working together with the timestamp within PostgreSQL?

1 Like