-----Original Message-----
From: Lester Caine [mailto:lester@...]
Sent: Tuesday, 8 June 2004 12:09 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Re: Select statement with Date

paul wrote:

> Thanks, my logout field is Timestamp.
> I want to compare only date value in the
> Timestamp field. How to do it.
> Say, I got Timestamp field with 07/06/2004 15:54:00
> I got date 07/06/2004 00:00:00
> How to do the date comparion between timestamp and date.

WHERE CAST( LOGOUT AS DATE ) = XDATE

You may need to 'CAST' the XDATE as a date, I feed a parameter which is
just the '07/06/2004'.

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services




Yahoo! Groups Sponsor


ADVERTISEMENT

<http://rd.yahoo.com/SIG=129rmj73v/M=298184.5022502.6152625.3001176/D=gr
oups/S=1705115386:HM/EXP=1086753925/A=2164330/R=0/SIG=11eamf8g4/*http:/w
ww.netflix.com/Default?mqso=60183350> click here


<http://us.adserver.yahoo.com/l?M=298184.5022502.6152625.3001176/D=group
s/S=:HM/A=2164330/rand=101581085>

_____

Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

* To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com
<mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe

>

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


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