Subject | RE: [firebird-support] American date format in SQL Statements |
---|---|
Author | Alan McDonald |
Post date | 2005-08-23T13:09:06Z |
> Hi allAug 23, 2005
>
> Is only American style of date allowed to be passed to an SQL
> statement?
>
> My VFP app uses British style of date dd/mm/yyyy and I was not able to
> query using SQL Pass Through.
>
> As soon as I queried using mm/dd/yyyy I got the results.
>
> Can I pass date in the format yyyymmdd (didn't work for me), or
> something that does not rely on particular date format, something
> generic.
>
> Please advise.
>
Alan