Recently, while trying to mash Team Foundation Server and SQL Server Reporting Services, I needed to convert a DateTime in SQL to a short date string. This is how I did it.
CONVERT(VARCHAR, ClosedDate, 101)
That's it. The definition for doing so is as follows:
CONVERT ( data_type [ ( length ) ] , expression [ , style ] )
MSDN has quite an article describing CONVERT in depth.
Related posts
Comments
April 22. 2009 15:20
good working.
ankara lazer epilasyon
June 15. 2009 15:55
Thanks for the nice share.
Calgary Dating
July 1. 2009 19:53
I blog and I have a love and www.estetik-merkezleri.com/burun-estetigi.html burun estetiği burun estetiği hate relationship with the comment feature.Commenting can lead to unintended flame wars,and is guaranteed to require investing time in http://www.tupbebegim.org tüp bebek merkezi (tüp bebek merkezi) which has been getting better only slowly. Many of the early anti-comment spam techniques were quickly hacked. Not everyone has enough time to keep their blog entries updated, http://www.sacekimii.com saç ekimi ( saç ekimi ) and http://www.sacekimiestetik.com saç ekimi saç ekim merkezi let alone delete a hundred poker spam entries every day or http://www.gogusestetigii.org göğüs estetiği göğüs meme estetiği install the blog patch of the month. Admitedly this is a http://www.vajinismustedavisi.org vajinismus vajinismus tedavisi ilişkiye girememe developer website, but not all developers want to spend their time specificly in web development.Only when the blog technology is http://www.otoarackiralama.com araç kiralama kiralık oto araç kiralama kiralık araç effortless can we assert a lack of blog commenting means the blogger is http://www.ankaralazer.net/ankara-lazer-epilasyon ankara lazer epilasyon laser lazer epilasyon unwilling to take what he is dishing out.
vajinismus
Home
© Rapidparts, Inc 2008 | 2950 Walkent Ct. NW, Grand Rapids, MI 49544 | Phone 616.647.2500 | info@rpionline.com