|
Home > Archive > MS SQL Server > July 2005 > Error 8114 Date data
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Error 8114 Date data
|
|
| aschossler 2005-07-05, 1:23 pm |
| I am trying to pull over data in for a specified date from an ODBC connected
AS/400 table, and I get the following error.
Server: Msg 8114, Level 16, State 8, Line 1
Error converting data type DBTYPE_DBTIMESTAMP to datetime.
Here's an example of what the field looks like in the AS/400 table:
1999-08-24 00:00:00.000
I thought that I could just as "where date = '2005-07-01 00:00:00.00'" but
it doesn't work.
Any thoughts??
Thanks in advance.
| |
| Adrian Zajkeskovic 2005-07-06, 3:23 am |
| This could be the limitation of the provider you use. Try a different or
newer provider.
Adrian
"aschossler" < aschossler@discussio
ns.microsoft.com> wrote in message
news:6C6CD9AF-F37E-459E-9A42- 64CE221D2E94@microso
ft.com...
>I am trying to pull over data in for a specified date from an ODBC
>connected
> AS/400 table, and I get the following error.
>
> Server: Msg 8114, Level 16, State 8, Line 1
> Error converting data type DBTYPE_DBTIMESTAMP to datetime.
>
> Here's an example of what the field looks like in the AS/400 table:
> 1999-08-24 00:00:00.000
>
> I thought that I could just as "where date = '2005-07-01 00:00:00.00'"
> but
> it doesn't work.
>
> Any thoughts??
> Thanks in advance.
|
|
|
|
|