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


manasa95 — Vertica Forum
Default Avatar

manasa95

manasa95

Vertica version 9.2 Date/Time Functions are working wrong when we provide column_name which contains many rows with "DateTime" (Column Sample: 2019-05-11 23:45:29), the hour value in output we receive is completely wrong when compare to actual hour from actual table (column_name) For Example: Column Sample: 2019-05-11 23:45:29` Query: --SELECT HOUR ( "column_name");-- Output: 12(Instead of 23. I got 12). or --SELECT TIMESTAMP_TRUNC("column_name",'HH'),"column_name",TRUNC("column_name") FROM Table_Name;-- or -- SELECT TO_CHAR ("column_name", 'HH24:MI:SS') AS my_date FROM Table_Name; -- But Hard-code is working correctly For Example: --SELECT HOUR (TIMESTAMP '2019-05-11 23:45:29');-- --SELECT HOUR ( '2019-05-11 23:45:29');-- I don't know y these functions are wrongly calculating. Can anyone Help to solve this issue?

Badges

Any minute now…

Activity

  • Not much happening here, yet.