0
I have a little problem regarding the command I am using to create a report using the postgresql, this is the command:
select DTNASCIMENTO from FRONT.CONTATO where contato.dtnascimento::DATE = :DATA_INICIAL
He is returning:
SQL Error [42883]: ERROR: Operator does not exist: date = integer
Hint: No Operator Matches the Given name and argument types. You Might need to add Explicit type Casts. Position: 73
If anyone can shed some light...
Good afternoon, friend! So that the staff can help you better, please give more details about what you are trying to do and add to
tagof the language you are using.– RxT
Hi Good afternoon...I am trying to make a query to extract data from a data base, where there is a column like "date" only I need to dat a "get" for when the user runs the query, be asked what date you want, query but when I will inform the date for filtering by the command: "select DTNASCIMENTO from FRONT.CONTACT Where contact.dtnascimento::DATE = :DATA_INICIAL" gives message and that the string is int, i think it is because of the column mask that this as xx/xx/xxxx <PLSQL> and thanks for the touch...
– Soloviofe