| Subject | RE: [IBO] DateTime Format For Firebird 3 and Delphi 10.3 Filter |
|---|---|
| Author | Jason Wharton |
| Post date | 2019-11-04T21:08:30Z |
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
-----Original Message-----
From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com]
Sent: Monday, November 04, 2019 1:19 PM
To: IBObjects@yahoogroups.com
Subject: [IBO] DateTime Format For Firebird 3 and Delphi 10.3 Filter
Is there an example of how to format a DateTime filter for IBOQuery and
Firebird 3 for using Delphi 10.3?
For the date there is no problem, but as soon as the time is added, I have
not been able to get any format to work. All forms I have tried get a
syntax error, including:
yyyymmdd hh:mm P
mm-dd-yyyy hh:mm P
FormatDateTime('c', Now);
------------------------------------
------------------------------------
___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !
http://tracker.ibobjects.com - your portal to submit and monitor bug reports
http://community.ibobjects.com - your portal to purchase and upgrade
------------------------------------
Yahoo Groups Links
------------------------------------
------------------------------------
___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !
http://tracker.ibobjects.com - your portal to submit and monitor bug reports
http://community.ibobjects.com - your portal to purchase and upgrade
------------------------------------
Yahoo Groups Links
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
-----Original Message-----
From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com]
Sent: Monday, November 04, 2019 1:19 PM
To: IBObjects@yahoogroups.com
Subject: [IBO] DateTime Format For Firebird 3 and Delphi 10.3 Filter
Is there an example of how to format a DateTime filter for IBOQuery and
Firebird 3 for using Delphi 10.3?
For the date there is no problem, but as soon as the time is added, I have
not been able to get any format to work. All forms I have tried get a
syntax error, including:
yyyymmdd hh:mm P
mm-dd-yyyy hh:mm P
FormatDateTime('c', Now);
------------------------------------
------------------------------------
___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !
http://tracker.ibobjects.com - your portal to submit and monitor bug reports
http://community.ibobjects.com - your portal to purchase and upgrade
------------------------------------
Yahoo Groups Links
------------------------------------
------------------------------------
___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !
http://tracker.ibobjects.com - your portal to submit and monitor bug reports
http://community.ibobjects.com - your portal to purchase and upgrade
------------------------------------
Yahoo Groups Links