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

Val_Melamed_1Val_Melamed_1
in General Discussion

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!

Comments

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...