NHibernate support for TIMESTAMP with TIMEZONE type in Oracle

Is it possible to map a .Net DateTime to a TIMESTAMP with TIMEZONE type in Oracle using NHibernate? Looks like it's not readily available in "Hibernate"

If this is not available out of 开发者_运维百科the box, can someone please direct to examples of how it may be achieved.

---

We were not able to find a proper mapping to this using NHb 3.1. However extended support for times (including timezone etc...) is available for SQL Server '07 onwards.

Our solution was to use a varchar field instead of timestamp and format the dates to include the timezone information. The consumer of this data was able to handle this change accordingly.

---

You could also convert them to UTC and store that.