Hi,

We are getting below error while running a query to show the date type data in SQL Server 2008.

Msg 8114, Level 16, State 8, Line 1
Error converting data type DBTYPE_DBTIMESTAMP to datetime.

Sample Query:
SELECT code, name, age, dob, doj
FROM [open_rowset]...[emp_data]

NOTE: dob & doj are date type fields.


Thanks In Advance
Ravi Mehrotra