General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Error with date field in SQL link server
Environment versions
Network:
Windows 2008 Server
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only