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.

Thank you!


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

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file