Problem with "time without timestamp" data type

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL
Post Reply
gcaplan
Posts: 3
Joined: Mon 02 Jan 2006 14:45

Problem with "time without timestamp" data type

Post by gcaplan » Fri 20 Jan 2006 17:10

Hi folks

Running a trial on PostgreSQLDirect and have run into an early problem.

I'm using the DataAdaptor to fill an untyped DataSet.

PG "date" fields are being handled OK. But "time without timestamp" fields are all being loaded as C# type System.TimeSpan with the value 00:00:00.

This is happening with my own code, and when I run the CoreLab DataSet demo. I've tried running FillSchema before running Fill, but this hasn't helped.

I'm very new to ADO.Net, so perhaps I'm misunderstanding something. I'd appreciate any pointers. We're planning to make a purchase, provided we can get things working OK.

Geoff

gcaplan
Posts: 3
Joined: Mon 02 Jan 2006 14:45

Post by gcaplan » Sat 21 Jan 2006 12:46

Sorry - I'm being dim. I realise now that it's being mapped to DateTime, and I have to parse the time out of the type.

Post Reply