Showing posts with label convert. Show all posts
Showing posts with label convert. Show all posts

Sunday, February 26, 2012

Error in DTS

Hi When I try to convert from Prervasive V8 to SQL using an ODBC connection. I receive the error message..

ParseDisplayName failed: The specified module could not be found.

Could anyone advise what this error is? And/Or how it could be resloved. This is happing when I press actualy try to convert. The wizard will go to that point then stop.

Thanks!

DTS or SSIS? This is an SSIS forum. For DTS questions, please visit:

http://groups.google.com/group/microsoft.public.sqlserver.dts?lnk=srg

Friday, February 24, 2012

Error in convert function

I use convert to work with Hijri functions
when i write
select convert (datetime,'29-10-1426',131)
the result is correct
2005-12-01 00:00:00.000

when I increase the date by one
select convert (datetime,'30-10-1426',131)
I get
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.

Why and how i solve itAs far as I know, the month 10 in Hijri calendar only has 29 days, so the second statement is supposed to fail. The next day to convert (datetime,'30-10-1426',131) is

select convert (datetime,'1-11-1426',131)

Regards,
Jun|||

The 10 month in Hijri calender is 30 days so
In Hijri calender any month can be 29 or 30 days
thanks