TSQL Minutes from midnight

Post date: Dec 6, 2009 9:38:53 PM

select datediff(mi, CAST(CONVERT(VARCHAR(10), GETDATE(), 101) AS DATETIME), getdate())