date convert error 2004-05-13 24:00:00.000

[alex]

Hi I importing data from db2 into sql
using openquery
In some case I have problem with date

example
DB2 date = '2004-05-13 24:00:00.000000'

I tried to convert it manually

sql server
select cast('2004-05-13 24:00:00.000'as datetime)

Server: Msg 242, Level 16, State 3, Line 1
The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.

do I have to substruct - 1 millisecond ?

[MAK]

http://forums.databasejournal.com/sh...threadid=35918