2 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 … |
The End.