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/yyyy format and SQL does not work because > it expects dd.mm.yyyy format. > > How can I change the format date for the parameter?
Either don't use strings for data, or make sure to always use the ISO-8601 format: yyyy-mm-dd. Mark -- Mark Rotteveel