Devart Forums

Posted: **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?

Posted: **Thu 30 Jun 2005 15:52**

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

Devart Forums

ExecuteScalar returns TimeSpan for Interval

ExecuteScalar returns TimeSpan for Interval

ExecuteScalar returns TimeSpan for Interval