On 4-11-2019 12:45, jbist...@yahoo.com [firebird-support] wrote:
> I run a SQL with where clause for date field received as a parameter.
>
> This parameter has the dd/mm/ format and SQL does not work because
> it expects dd.mm. format.
>
> How can I change the format date for the
1. Change parameter to be date, not string containing date.2. Reformat it
before use in query3. Reformat it in query using cast as date using
substringRegards,Karol Bieniaszewski
null
Hi,
I run a SQL with where clause for date field received as a parameter.
This parameter has the dd/mm/ format and SQL does not work because it
expects dd.mm. format.
How can I change the format date for the parameter?
Thanks in advance.
Jordi