1
Answer

How to add datetime with Time Format add in sql server 2005

Nirmal KumarC

Nirmal KumarC

9y
656
1
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
Answers (1)