Skip to main content
Question

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

  • Jul 4, 2023 6:21 AM UTC
  • 1 reply
  • 54 views
Level 1
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