With the time data type (I'm using Microsoft SQL Server 2008), is there any way to take only the minute part out of it? I tried to pass the time to datepart and datediff function but both refused to work.
Example: I want to get 15 from 04:15
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
select datepart(minute, '04:15')
DATEPART() function, with
minute as the datepart param.
declare @current_time time select @current_time = getdate() select datepart(minute, @current_time) as current_minute