Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
configuring and Understanding current timestamps /local timestamps
Hi, I'm going through Guidebook trying to understand how the timestamps are determined, but cannot find anything concrete. Our Vertica instance was simply "installed out of the box" So I do: select localtimestamp - which yields 2013-05-08 16:46:24.657677 but when doing select current_timestamp, it yields 2013-05-08 15:46:24.657677 The local timestamp (16:46) is correct and what we want. What do i need to configure things to get me the right time? More importantly is there documentation pointing this stuff out and explaining it from an Administrator's Guide. Also wondering if Vertica didn't adjust for daylight savings or what. Or we just misconfigured things from the start Thanks