ExecuteScalar returns TimeSpan for Interval

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL
Post Reply
szinkopa
Posts: 16
Joined: Mon 27 Jun 2005 21:12

ExecuteScalar returns TimeSpan for Interval

Post by szinkopa » Thu 30 Jun 2005 13:13

I ran this:

Cmd.CommandText="select cast('1 year' as interval)";
object o=Cmd.ExecuteScalar();

The debugger shows that o contains a TimeSpan, so the year component goes away. This should return PgSqlInterval, shouldn't it?
Top
Yuri
Posts: 140
Joined: Mon 08 Nov 2004 12:07

ExecuteScalar returns TimeSpan for Interval

Post by Yuri » Thu 30 Jun 2005 15:52

Please use method PgSqlDataReader.GetPgSqlInterval() method to obtain a PgSqlInterval value.
Top
Post Reply

Return to “dotConnect for PostgreSQL”