MAX and MIN date problem

Hi Ramalinga,

I Have try Ur doubt it's working fine the query u have used is right one.

Main thing is first check ur database column datatype whether is Date or Datatime .
I have tried with Date datatype it's working Fine.

Here what i have received as output :


select MIN(DateOf_joining) from Employee =====> Gives me : 2008-07-07

And

select MAX(DateOf_joining) from Employee =====> Gives me :2011-04-01

So just Check ur datatype field of DateOf_joining column in ur Employee table.

Al d best.

Hm, Based on your result it looks like you actually store the dates in a varchar field, don't. Modify the column type to date (or datetime if you need) and the query you have already written works correctly.

To test the usage of date datatype you can try running this:

SELECT MAX( CONVERT(DATE, DateOf_joining, 103) ) 
FROM  Employee

That would convert your string to dates and get the maximum