Indeed if it were but that easy, I have explained in another posting what I
must achieve. It has to take place in a SP in a for loop AND where dateout
< start of day today AND then create new dateout and datein with date
portions filled in and time portions set to 00:00:00

:-(

R.



_____

From: Svein Erling [mailto:svein.erling.tysvaer@...]
Sent: Friday, December 05, 2003 14:00
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Re: date functions



I think that <date> + <integer> results in another <date>. Have you
tried something like

SELECT <columns>
FROM <table>
WHERE DateColumn> BETWEEN :InDate AND :InDate + 2

HTH,
Set






Yahoo! Groups Sponsor



ADVERTISEMENT

<http://rd.yahoo.com/SIG=12coli6uk/M=258297.4271147.5470572.4049140/D=egroup
web/S=1705115386:HM/EXP=1070711997/A=1683962/R=0/*http:/www.techsmith.com/rd
r/ban/syah/default.asp> click here



<http://us.adserver.yahoo.com/l?M=258297.4271147.5470572.4049140/D=egroupmai
l/S=:HM/A=1683962/rand=234060007>


To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to the Yahoo!
<http://docs.yahoo.com/info/terms/> Terms of Service.



[Non-text portions of this message have been removed]