Nirmal KumarC

Nirmal KumarC

  • NA
  • 327
  • 79.6k

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

Mar 7 2015 9:35 AM
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)