Custom datatype operators in Sql Server?

Question

In Sql Server 2008, they added new DATE and TIME datatypes, complimenting DATETIME.
I wanted to combine a DATE and a TIME to a DATETIME, and thought maybe the obvious would work, and I could do

SELECT DATEFLD + TIMEFLD FROM MYTABLE

and DATE + TIME would return the corresponding DATETIME. Unfortunately, that's a little too obvious, and did not work. So I am wondering, does Sql Server have any way to override operators, to create an override for "+" to handle DATE + TIME => DATETIME .

Answer 1

CAST to smalldatetime first

DECLARE @d date, @t time

SELECT @d = getdate(), @t = getdate()

SELECT cast(@d as smalldatetime) + cast(@t as smalldatetime)

I can't recall where I saw this and I don't remember why. sorry

SQL does not provide overloading, luckily...