Subject Re: [IBO] DateTime Format For Firebird 3 and Delphi 10.3 Filter
Author Jack Mason
Post date 2019-11-11T16:45:55Z
Thanks.  Got it to work with all 8 of the suggested formats.  There must have been a bug in the simple 2 line code I tried before.

Jack

On 11/5/2019 12:55 PM, 'Jason Wharton' supportlist@... [IBObjects] wrote:
 

I just did a Google search and found this link:
https://firebirdsql.org/en/firebird-date-literals/
 
Let me know if this is helpful.
 
Thanks,
Jason Wharton
 

From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com]
Sent: Tuesday, November 05, 2019 10:51 AM
To: IBObjects@yahoogroups.com
Subject: Re: [IBO] DateTime Format For Firebird 3 and Delphi 10.3 Filter

The thing I haven't discovered is a format string that Firebird SQL will process.  What is that format?

Jack

On 11/4/2019 4:08 PM, 'Jason Wharton' supportlist@... [IBObjects] wrote:
 

You will want to use the format string that Firebird SQL is able to process.
The other way is to make it an input parameter and then to provide that
value after preparing the query.

Jason Wharton
www.ibobjects.com