| Subject | Re: [firebird-support] Where clause from date field with wrong format |
|---|---|
| Author | Mark Rotteveel |
| Post date | 2019-11-06T16:28:57Z |
On 4-11-2019 12:45, jbistuer@... [firebird-support] wrote:
ISO-8601 format: yyyy-mm-dd.
Mark
--
Mark Rotteveel
> I run a SQL with where clause for date field received as a parameter.Either don't use strings for data, or make sure to always use the
>
> This parameter has the dd/mm/yyyy format and SQL does not work because
> it expects dd.mm.yyyy format.
>
> How can I change the format date for the parameter?
ISO-8601 format: yyyy-mm-dd.
Mark
--
Mark Rotteveel