Subject RE: [IBO] DayOfWeek function?
Author Eric Tishler

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

Best Regards,

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

-----Original Message-----
From: Scott Taylor [mailto:scott@...]
Sent: Wednesday, May 05, 2004 4:58 PM
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


IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________ - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !

Yahoo! Groups Sponsor

<*> click here



Yahoo! Groups Links
* To visit your group on the web, go to:

* To unsubscribe from this group, send an email to: <>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of <> Service.

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