DATE supports date functions like DATEADD and DATEDIFF which INT does not. DATE also automatically includes validation because only valid dates are allowed. With INT you'd presumably have to add validation to validate the date values. Certainly use DATE unless you have some very good reason not to.
As a matter of detail, DATE is smaller than INT (3 bytes instead of 4).
answered May 31 '10 at 09:50 AM
i think int datatype is batter because it occupy less space then date datatype. and we can convert it to date or datetime whenever neccessory. is it true?
answered May 31 '10 at 09:26 AM