Re: selectiing a month out of a date

2003-08-28 Thread Roger Baklund
* 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

selectiing a month out of a date

2003-08-28 Thread Creative Solutions New Media
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