Howdy,
We have a MySQL DB and use Unix time for many of the key fields. MySQL has a function called UNIX_TIME() that makes it easy to get Unix time (number of seconds since 1 Jan 1970). How do I get this value in Vertica?
Thank you
Unix Time
Moderator: NorbertKrupa
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: Unix Time
Jim Knicely
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Re: Unix Time
Thanks, Jim! Hey, do you know why Jan 1, 1970 was chosen as start date? Seems weird. Something to do with Nasa and the moon landing?
Have a GREAT day!