Skip to content

Edoardo Vignati 👨🏻‍💻

› Always looking for awesome things

Menu
  • Studies
  • Publications
  • Skills
  • Portfolio
  • Projects
  • Career
  • Blog
  • 🇮🇹 Servizi
Menu

Category: Tips and tricks

PostgreSQL date/time tips

Posted on 28/12/201801/12/2020 by Edoardo

I know, editing date/time fileds in a database is not easy and sometimes we don’t use good techniques to do it because of the difficulty. In some of my projects I had to manage timestamp, so, I would like to share some useful tips. Split a timestamp into two elements: SELECT d[1] AS date, d[2]…

Continue reading
  • Previous
  • 1
  • 2
© 2025 Edoardo Vignati 👨🏻‍💻 | Powered by Minimalist Blog WordPress Theme