* Creative Solutions New Media
> I have a table with a date field (called myDate for example)
> formatted like -xx-xx.
>
> I want to do a query searching for all dates with the month of
> August, for example.
>
> How would I do that?
SELECT datecol FROM mytable WHERE MONTHNAME(datecol)="A
Hi,
I have a table with a date field (called myDate for example) formatted like
-xx-xx.
I want to do a query searching for all dates with the month of August, for
example.
How would I do that?
Tim Winters
Manager, Creative Development
Sampling Technologies Incorporated (STI)
[EMAIL PROTECTE