Vertica Interval and .NET TimeSpan
The documentation for mapping ADO.NET TimeSpan and Vertica's Interval year/month types is pretty vague. It simply says: "Note: There are 13 VerticaType values for the 13 types of intervals. The specific VerticaType used determines the conversion rules that the driver applies. Year/Month intervals represented as 365/30 days."
I'm guessing that if I have a TimeSpan value of 425 days it will be transformed to a value of type "interval year to month" as 1 yr 2 months and vice versa.
Can you please elaborate on the details.