I'm using SQL Server 2005 and I have a DateTime column.
How can I multiply the hour and minute of a DateTime column by 1.2 and return the new value?
SELECT
DATEADD(
s,
DATEDIFF(s,DATEADD(dd, DATEDIFF(dd, 0, GETDATE()), 0),GETDATE())*1.2,
DATEADD(dd, DATEDIFF(dd, 0, GETDATE()), 0)
)