Skip to main content

Vertica Interval and .NET TimeSpan

  • September 3, 2014
  • 1 reply
  • 8 views

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!

1 reply

Val_Melamed_1
  • Author
  • Participating Frequently
  • October 1, 2014
Is there someone who can answer the question, please? It has been posted 4 weeks ago...