Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rwaldron
Posting Yak Master
131 Posts |
 Posted - 2005-06-30 : 10:50:27
|
| Hi all,Thx for the help so farI was receiving the "error "converting data type DBTYPE_DBDATE to datetime" on my select statement to a Linked pervasive DB.I now know that this is due to the fact that some fields on the linked server conatain Zero's instead of a valid date , even though the data type is set to date...My select statement runs perfectly until it hits the first occurance of a date as zero and then it stops..My current Statement is SELECT *From OPENQUERY(servicebase_live_link, 'Select date_booked from jobs')After some help from you guys I now Know I need to do the following..Use a "case" stament in my "select" with a check for "ISDate()" adding some other tests to only return dates that are valid else NULL.name each column in the select statement instead of using "select *".Can anyone help me with the correct code please Cheers.Ray. |
|
|
KLang23
Posting Yak Master
115 Posts |
Posted - 2005-06-30 : 11:02:39
|
| Replied in another section.Post a question only once, and only in one section. |
 |
|
|
|
|
|
IsDate() Else set to null