DATEADD (datepart , number, date )The designers were consistent with putting the 'datepart' as the first parameter, but for DATEADD, why did they made the base date the last parameter? I think it should be consistent with DATEPART and DATEDIFF, so that the second parameter is always a DATETIME.
DATEDIFF ( datepart , startdate , enddate )
DATEPART ( datepart , date )
No comments:
Post a Comment