As we all know, SQL Server 2008 comes with a time data type. Obviously, as the name itself denotes, this data type is capable of storing the time sans the date component. So, how would one populate a time field or variable with the current system time? One would obviously think of the getdate() function and some fancy operations to extract the time component out of it. At least, that is what I thought. But, the answer is much more simpler:
DECLARE @CurrentTime time
SET @CurrentTime = GETDATE() SELECT @CurrentTime
| Share this post : |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |
No comments:
Post a Comment