[datepart] Forum Topics

I am developing a Lease Information Management System. This system is related with Land rent Contracts. Every contract have a Begining date and Expiry date. For example Begingin Date is: 01-08-06 And Expiry Date is : 31-07-16 I have store these 2 dates in DB. Payment will be given to …

Hi does anyone know how to update a datepart? update table set datepart(dd, tablename) = '30' where ?? What I want to do is udpate records date data but only the day so where all of the records > '2009-07-25 00:00:00.000' are updated to 30 i.e. 2009-07-30, I want to …