selecting max and min year

#1

I have a table that has a DateTime column which uses a DataTime
datatype. How do I retrieve the minimum and maximum year using ms sql?

Eugene Anthony

*** Sent via Developersdex http://www.developersdex.com ***

#2

On Mar 15, 2:47 pm, Eugene Anthony <solomon_13... (AT) yahoo (DOT) com> wrote:

Quote:

I have a table that has a DateTime column which uses a DataTime
datatype. How do I retrieve the minimum and maximum year using ms sql?

Eugene Anthony

*** Sent via Developersdexhttp://www.developersdex.com***

select max(datepart(yy, myColumn)) maxYear,
min(datepart(yy, myColumn)) minYear
from myTable

#3

SELECT DATEPART(yy, MAX (foo_date)) AS max_year,
DATEPART(yy, MIN (foo_date)) AS min_year
FROM Foobar;

It is important not to put the DATEPART() inside the aggregate
functions. It is easy to find the min and max on a column via indexes
or statistics tables. Once you put a funciton inside an aggregate
function, you cannot use these tools and have to do a table scan.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

selecting max and min year

comp.databases.ms-sqlserver comp.databases.ms-sqlserver

selecting max and min year - 03-15-2007 , 12:47 PM

Re: selecting max and min year - 03-15-2007 , 01:47 PM

Re: selecting max and min year - 03-15-2007 , 04:41 PM