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]…