update and concatenate columns POSTGRESSQL

0

I would like you to help me with this doubt. I want to make an update in a new attribute that I add to my table, the situation is the following when doing that update I want to concatenate three columns. when I execute this code:

update saber2012_1 set estu_fecha_nacimiento = Concat(estu_nacimiento_dia,'/',estu_nacimiento_mes,'/',estu_nacimiento_anno);

nulls many attributes that previously had values for example what they see in null in the image before had their respective values.

    
asked by juancamilovallejos0 01.04.2018 в 07:58
source

0 answers