Setting timepart of a datetime in T-SQL

18 March, 2013 Roel van Lisdonk 0 Comments 1 category

select cast((substring(convert(varchar, getdate() , 20), 0, 12) + '10:00:00') as datetime)

Tags: T-SQL

18 June, 2018 Roel van Lisdonk 0 Comments 1 category

To create WordPress blog posts from C# I will…

27 October, 2010 Roel van Lisdonk 23 Comments 1 category

I was getting the error "Unrecognized attribute 'targetFramework'. Note that…

21 June, 2011 Roel van Lisdonk 0 Comments 1 category

To read mine Hotmail e-mails in Microsoft Outlook 2010, I…

Knowledgebase