How to add datetime with Time Format add in sql server 2005
Dear Sir,
Sqlserver Query bellow query. Running Sql server 2008 was successfully Runned.
SELECT @ChkFromDate = CAST(''2015-02-02 00:00:00.000'' AS DATETIME) + CAST('07:30' AS DATETIME)
This above query result is 2015-02-02 07:30:00.000.
I am tried above query in sqlserver 2005 running but error came.so how to get this result in (2015-02-02 07:30:00.000) ,so how to join date with time add in Sql server 2005.
Thanks