We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


Hi What is the datatype need to use for storing date , time along with meridain indicator — Vertica Forum

Hi What is the datatype need to use for storing date , time along with meridain indicator

Comments

  • wwong2wwong2 Employee
    Hi, there are several different datatypes related to date and time.  
    Date
    Interval
    Time
    Timestamp
    TimestampTZ
    TimeTZ

    Please refer to the documentation for more details and infomation about each.

    Regards
     

Leave a Comment

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