Subject | Date parameters |
---|---|
Author | Santiago |
Post date | 2003-10-30T23:10:04Z |
Hi,
I have a stored proc that receive date parameters, that will be used
for a "select" statement.
I'm calling the stored proc as:
select * from factura_relacion('IMPORTE', '01.01.2005', '01.01.2001')
What is the correct format to specify dates in a function call like
this in ISQL ? Is it correct as written?
(The next question is a bit Delphi related, and is about the same
stored proc function call; sorry for any inconvinience )
If I call it from Delphi, should I pass the dates as text, or as a
TDate value?
Thank you,
Guillermo
I have a stored proc that receive date parameters, that will be used
for a "select" statement.
I'm calling the stored proc as:
select * from factura_relacion('IMPORTE', '01.01.2005', '01.01.2001')
What is the correct format to specify dates in a function call like
this in ISQL ? Is it correct as written?
(The next question is a bit Delphi related, and is about the same
stored proc function call; sorry for any inconvinience )
If I call it from Delphi, should I pass the dates as text, or as a
TDate value?
Thank you,
Guillermo