Change of data type of columns in postgresql

0

Beforehand I appreciate the help, it turns out that in a postgresql database change the data type of a timestap column without time zone by the timestap type with time zone, this change eliminated the part of the date that it was reflected in the data and I leave the time format, although I change the data type again the data does not return to the way it was before, my question is how to recover the date part in the data, I can say that I have another column where this is only the date in date type

    
asked by Juan Jose Perdomo Forero 30.11.2018 в 00:24
source

0 answers