Jirka's Public Notepad

Data Engineering | Python | SQL Server | Teradata

December 6, 2018 By Jiří Hubáček Leave a Comment

Timezone handling in Teradata

I needed to display local timestamps of UTC stored data in my report. But I didn't want to just blindly add or subtract hours as this wouldn't reflect

September 22, 2017 By Jiří Hubáček Leave a Comment

Casting Char to Timestamp and Date in Teradata

Casting character data to timestamp or date data type is a common task during ETL development. Yet, I couldn’t learn the formatting characters by

June 29, 2015 By Jiří Hubáček 2 Comments

Teradata SQL: UPDATE using JOIN

Recently, I came across this brain storage distribution schema. IMHO 2% for 'stuff I should know for work' is a little exaggerated considering

  • GitHub
  • LinkedIn
  • RSS
  • Twitter
© 2021 · Jiří Hubáček, PGP