Loading

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

Nirmal KumarC

11y1.2k

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

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

ganesh devlekar11y ago
You can Use DATEADD function in sql server

select DATEADD(HOUR,7,DATEADD(minute,30,'2015-02-02 00:00:00.000'))