You are currently browsing comments. If you would like to return to the full story, you can read the full entry here: “SQL Server Cast”.
Random MVP RSS Feeds- [Aaron Bertrand] Cumulative Updates available for SQL Server 2008 SP2 & SP3: Today Microsoft has released two ne... http://t.co/WrwqSBf0
- [Aaron Bertrand] How SQL Saturday could be better: I've been to a lot of SQL Saturdays. They are great events to... http://t.co/bLe97UD5
- [Aaron Bertrand] SQL Server 2008 R2 Service Pack 2 CTP is available: You can download the service pack 2 CTP fro... http://t.co/kblQTr2y
- [SQLTeam] Why to avoid SELECT * from tables in your Views: -- clean up any messes left over from before: if OB... http://t.co/GIDxRhEY
- [Kalen Delaney] Did You Know? Turning Off Locking: Back when the lock manager was rewritten for SQL Server 7, an... http://t.co/lzEEpC11
- [Aaron Bertrand] A cautionary tale about grandfathering CAL licenses in SQL Server 2012 Enterprise: I've tried t... http://t.co/1Uoru0DD
- [Kalen Delaney] Geek City: Build a Big Table with a Columnstore Index: I was looking all over to find a big tabl... http://t.co/kzBZMTZu
- [SQLTeam] ClearTrace Performance on 170GB of Trace Files: I’ve always worked to make ClearTrace perform well. T... http://t.co/R24uwgOl
- [SQLTeam] ClearTrace Beta for SQL Server 2012: I have a beta version of ClearTrace that supports 2012. You can ... http://t.co/IrXM7ZFb
- User Defined Functions and Performance - There is definitely a lack of... http://t.co/YdHjOTuH #fb
Connect
Is the word to be used really ‘append’? “you need to append the number comprising the date into a string.” Is it really a ‘padding’ of the number 0?
Looks like it should be right instead of left
Agree! If you use left and it’s i.e day 23 you will get ’02′ with left method.
What about @mydate =’2009-12-11′, output =20090201 ?
Hi, You can find that answer here:
http://sqlserverplanet.com/sql/cast-date-with-no-time/
SELECT CONVERT(varchar(12),GETDATE(), 112) — 20090629
Any date with double digit month and/or day is incorrect with this method (0 + left(x,2) will always start with 0)