Filter by month and year - Level Extreme

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

Filter by month and year

Message

From

05/01/2005 09:53:40

Winan Jaya
Jakarta, Indonesia

To

05/01/2005 09:49:40

Yuri Rubinov
Philadelphia, Pennsylvania, United States

General information

Forum:

Microsoft SQL Server

Category:

SQL syntax

Title:

Re: Filter by month and year

Miscellaneous

Thread ID:

00974373

Message ID:

00974383

Views:

18

I mean in SQL syntax? ..
SELECT * FROM SALES WHERE MONTH(DATEFIELD) = 12 AND YEAR(DATEFIELD) = 2004 .. am I correct? .. please advise

TIA
Winanjaya

Click here to load this message in the networking platform