To get only the Time portion of a DateTime variable in Transact-SQL, you can use the following function:
-- Returns only the time portion of a DateTime, at the "base" date (1/1/1900)
CREATE function [dbo].[sudf_Common_TimeOnly]
(
@dtDateTime datetime
)
returns datetime
as
begin
-- Get the time only
return dateadd(day, -datediff(day, 0, @dtDateTime), @dtDateTime)
end
Please notice that the base date is January 1st 1900. Any dates/times prior to this day won’t work,
The day of week for a given date can in Microsoft SQL server be calculated based on the @@datefirst system variable and the datepart function in Transact-SQL. The value returned from datepart is not constant but depends on the first day of week specified by the @@datefirstvariable. In modern programming languages like C# we will get a constant value for each […]
In Transact-SQL the first day of week can be calculated based on the @@datefirst system variable. The variable will return different values depending on which language has been configured for the server. For US English the first day of week will be set to 7, i.e. Sunday, while for other regions the first day will […]
The most common way is to store colors in a SQL database as a string, i.e. the HTML color code (ex. #FFFFFF). The colors can also be stored as 32 bit integers. A 32 bit color value (including alpha channel) can be calculated in the following way: @Alpha * 16777216 + @Red * 65536 + @Green * 256 + @Blue The complete user-defined […]
2 thoughts on “MS SQL: Get the Time portion from a DateTime”