| | |
How can you update Datepart day
Please support our MS SQL advertiser: Intel Parallel Studio Home
![]() |
•
•
Join Date: Sep 2009
Posts: 3
Reputation:
Solved Threads: 0
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 leave the timestamp portion alone in the records.
Thanks in advance.
Sonia
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 leave the timestamp portion alone in the records.
Thanks in advance.
Sonia
![]() |
Similar Threads
- Next Google PR Update (Search Engine Optimization)
- Browsing Sites that update (Web Browsers)
- Slowness in replying to threads? (DaniWeb Community Feedback)
- installed WMP 11...then tried uninstalling...now windows will not start (Windows NT / 2000 / XP)
- Verify i deleted all the BAD files??! (Viruses, Spyware and other Nasties)
- Unique Advertising Opportunity for Webmasters/Multi-Site Owners (Ad Space for Sale)
- Decent MSN/Yahoo rankings, but not google (Search Engine Optimization)
- What's wrong with the truth?? (Search Engine Optimization)
- this code isn't working...why..plz help (C++)
- my computer is going to have a heart attack (Viruses, Spyware and other Nasties)
Other Threads in the MS SQL Forum
- Previous Thread: MSSQL Server problem writing VARBINARY data.
- Next Thread: Anyway to use Having in this SQL STMT?
| Thread Tools | Search this Thread |
7 64bit 2010 apple browser bulletin collaboration control database date date/time datepart design error errors file firefox firmware gamer gaming install internet iphone iphone2.1 java jvm leopard list mac microsoft mozilla news object osx panel patch playstation ps3 pwnage remote security sharepoint software sony sqlserver syntax trojan update upload virus vulnerability win windows xp







