Skip to main content
Question

uploaded parquet file the timestamp is different how to convert into readable way in transformation using sql

  • July 4, 2023
  • 1 reply
  • 4 views
S
Level 0
uploaded parquet file the timestamp is different how to convert into readable way in transformation using sql

1 reply

kailash.potha12
Level 10
Forum|alt.badge.img+6

Hi Suchitra, You can try CAST function CAST ( Field AS DATE)

https://www.vertica.com/docs/9.3.x/HTML/Content/Authoring/SQLReferenceManual/LanguageElements/Operators/DataTypeCoercionOperatorsCAST.htm

Community Code of ConductAccessibility statement