Vertica Interval and .NET TimeSpan

Val_Melamed_1

Hello,

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.

Thank you!

Val_Melamed_1

Is there someone who can answer the question, please? It has been posted 4 weeks ago...