Is there any way of using the Oracle datatype “TimeStamp with local timezone” without writing a custom type converter? We are using ODP.net (Oracle.DataAccess, Version=2.102.2.20) and Oracle 10gR2.

Thanks.

Isn't this a setting in the database. Timestamps are mapped into .NET DateTime dataType. And as far as I know timezones are stored in the metadata of the database, so it would automatically convert any passed dateTime into the specified timezone.

Based on the above I don't think you will need a TypeConverter.

ODP.NET maps it to a DateTime struct, so we return the value as a DateTime struct. Into which type do you want to convert it into?

Thanks! We did not need a typeConverter. Corrupted data resulted in strange errors. Timestamp with local timezone works like a charm.