26 November, 2010
Roel van Lisdonk
0 Comments
1 category
CONVERT(VARCHAR(8),GETDATE(),108)
Result
14:12:30
Other examples
print convert(varchar(30),getdate(),121)
— Result: 2011-05-09 12:04:31.883
— Result: 2011-05-09 12:04:31.883
print convert(varchar(30),getdate(),113)
— Result: 29 Apr 2011 13:41:23:327
— Result: 29 Apr 2011 13:41:23:327
Tags: T-SQL
Category: Uncategorized
Related Posts
Transforming an input file to an output file in C#, by using XSLT.
22 December, 2011
Roel van Lisdonk
0 Comments
1 category
Just a code snippet for transforming an input file to…
Nice one Microsoft: Internet Explorer 9 will not let me download Visual Studio 11, but Google chrome will.
7 November, 2011
Roel van Lisdonk
0 Comments
1 category
When I click to download Microsoft Visual Studio 2011 on…
Custom error pages in ASP .NET 4.0
2 June, 2010
Roel van Lisdonk
0 Comments
1 category
If you want to use a custom error page in…