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
  • 0 views
A
  • Anonymous
uploaded parquet file the timestamp is different how to convert into readable way in transformation using sql

1 reply

A
  • Anonymous
  • July 4, 2023

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

Terms & ConditionsAccessibility statement