timestamp with timezone postgresql mapping

Question

How Can I map "timestamp with time zone" datatype from postgreSql to System.Data.DbType I need to pass parameter as it will go to the column which has "timestamp with time zone"

following is my code:

var pOrderDate = cmdOrder.CreateParameter();
pOrderDate.ParameterName = "OrderDate";
pOrderDate.DbType = System.Data.DbType.DateTime;
pOrderDate.Value = objOrder.OrderDate;
cmdOrder.Parameters.Add(pOrderDate);

Following line causes problem:

pOrderDate.DbType = System.Data.DbType.DateTime;

@Freelancer - if you not agree to use English in this forum - find other place for your converastion. — MikroDel
– MikroDel, Commented Apr 5, 2013 at 11:35
@Freelancer - blog.stackoverflow.com/2009/07/non-english-question-policy — MikroDel
– MikroDel, Commented Apr 5, 2013 at 11:49

Manus Creationis · Accepted Answer · 2013-04-12 14:01:33Z

2

Have you considered trying the DateTimeOffset class in .NET?

I'm unaware of how it maps to Postgres "DateTime with Timezone" type, but it has a 1:1 correlation with what I believe would be the MSSQL equivalent (also called DateTimeOffset).

Note that the naming here is quite poor - the type represents a DateTime + Offset, and not just the Offset itself.

answered Apr 12, 2013 at 14:01

Manus Creationis

611 bronze badge

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

timestamp with timezone postgresql mapping

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related