The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

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!


Leave a Comment

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