I created a view that strips out the date from a datetime field. It shows as a date field in 2008 and functions as a date field when I query it. But when another program on another server tries to access the data (from sql 2012) an error pops up. Note that this other server accessed the data fine until I converted the datetimefield to a date field.
Error message is:
reading the data of the record X failed
Reading the data of the column BookingStartDate failed.
The data type conversion 'dbtype_wVarchar - bddate is not supported
This is the code I used to create the view:
SELECT tblBooking.ID AS BookingId, tblBooking.TimeBookingStart, CAST(TimeBookingStart AS date) AS BookingStartDate