Scott,

You are THE MAN! This works great. Thank you so much!

Best Regards,
Eric

Eric Tishler
Software Architect
Resolute Partners, LLC
Phone: 203.271.1122
Fax: 203.271.1460
etishler@...

-----Original Message-----
From: Scott Taylor [mailto:scott@...]
Sent: Wednesday, May 05, 2004 4:58 PM
To: IBObjects@yahoogroups.com
Subject: Re: [IBO] DayOfWeek function?


Eric Tishler said:

> Does IB Objects (or SQL in general) have a way to select records from a
> specific day of the week based on a DateTime field?

EXTRACT(WEEKDAY FROM myDate) will return 0-6 from Firebird SQL works with
both TimeStamp and Date type fields

--
Scott



___________________________________________________________________________
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 !





Yahoo! Groups Sponsor


ADVERTISEMENT
<http://rd.yahoo.com/SIG=129l0a2ab/M=295196.4901138.6052515.3001176/D=groups/S=1705007183:HM/EXP=1083877135/A=2128215/R=0/SIG=10se96mf6/*http://companion.yahoo.com> click here

<http://us.adserver.yahoo.com/l?M=295196.4901138.6052515.3001176/D=groups/S=:HM/A=2128215/rand=358360222>

_____

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

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

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


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