thanks for reply Michael
Its seems to be implementation issue..
yet i have came across other problem now ...
for "select getdate()"
DBlib returns:-
11/28/2012 3:28:38.446 AM
CTlib returns:- CTlib does special handling for DATETIME
11/28/2012 3:28 AM
it would be great if there is some solution on perl side as this have been used on many procedures and changing all the procedure will be problem.