-----Original Message-----
From: Helen Borrie [mailto:helebor@...]
Sent: Tuesday, 8 June 2004 12:10 PM
To: firebird-support@yahoogroups.com
Subject: RE: [firebird-support] Re: Select statement with Date

At 11:03 AM 8/06/2004 +0800, you wrote:

> Hi,
> 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.

Select EmpName, EmpID from EMP where logoutdate >= CURRENT_DATE AND
logoutdate < (CURRENT_TIMESTAMP + 1)

/heLen





Yahoo! Groups Sponsor


ADVERTISEMENT

<http://rd.yahoo.com/SIG=1290skmp9/M=298184.5022502.6152625.3001176/D=gr
oups/S=1705115386:HM/EXP=1086754240/A=2164338/R=0/SIG=11ed4vqbv/*http:/w
ww.netflix.com/Default?mqso=60183349> click here


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

_____

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]