Re: DDS Time vs. DDL Time

[Pete Hall <pete@xxxxxxxxxxxxxx>]

On Thu, 20 Oct 2011 12:21:03 -0500, Mike Wills wrote:

> Working line:
> cmd.Parameters.Add("@SUPERVISOR_SIGNED_TIME", iDB2DbType.iDB2Time).Value
> =
> leaveRequest.SupervisorSignedDateTime.ToString("HH.mm.ss");
>
> Non-working line:
> cmd.Parameters.Add("@PAYMENTTIME", iDB2DbType.iDB2Time).Value =
> transactions.Transaction.TransactionTimestamp.ToString("HH.mm.ss");
>
> Both leaveRequest.SupervisorSignedDateTime and
> transactions.Transaction.TransactionTimestamp are of the same C# type
> (DateTime).
>
> The error is:
> IBM.Data.DB2.iSeries.iDB2ConversionException was unhandled Message=A
> conversion error occurred.
> Source=IBM.Data.DB2.iSeries
> MessageCode=111
> MessageDetails=Parameter: 13.

I work in a shop where the default date format is *USA, and to make my 
programs work I have to specify both DATFMT(*ISO) in my RPG H spec and 
add EXEC SQL SET OPTION DATEFMT=*ISO at the top of the C specs in order 
to get things to work correctly. Not the same as your issue, but possibly 
similar.