select given month from date field

[Shrp]

Given records containing a date field, how do you select
all records where the month portion of the date equals a
given month? Same with the date portion equaling a
given date?

Thanks!

 

[Guest_imported]

Most data base systems provide some function to extract the year/month/date portions from a date value, such as SELECT *
FROM mytable
WHERE month(mydatefield) = wantedmonth

There should be further functions to select year(mydatefield) and day(mydatefield) .

Hope this helps

milan432

 

[grega]

What DBMS? In Sybase, use datepart(month, datefield).

Greg.

 

[Shrp]

This is ODBC accessing Access. Thanks!

 

[tlbroadbent]

I recommend posting Access query questions in forum701, "Microsoft: Access Queries and JET SQL." Access JETS SQL differs from ANSI SQL in many ways.

Either Month(datecol) or datepart("mm",datecol) will return the numeric value of the month. You may want to consider adding "Year" to the selection criteria if the tables contains multiple years of data. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.

 

[Shrp]

I also checked the help inside Access, and it lists
DatePart("m",datefield) as the way to go.

I try a:

SELECT * from xxx where DatePart("m",datefield) = 'Mar'

...and I get an "Internal Server Error". I'm using IIS.

 

[tlbroadbent]

Datepart("m",[date]) returns a number not a string.

Use format(date(),"mmm&quot to return a 3 character month name. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.