Change date of birth PostgresSQL

Navigation
0

Hello good day I have the following problem, I have a database in which the dates of birth have been entered in a different way as shown in the image. My question is how can I get the same format on all birth dates, because I have dates this way 10/03/95 and I want everything to be this way: 03/10/1995. Thanks for the help.

    
asked by juancamilovallejos0 08.04.2018 в 17:32
source

1 answer

0

Postgre has a function that can help you:

link

I do not know what type of data your column is. But you could use those functions to update them to the format that works for you.

Greetings!

    
answered by 09.04.2018 в 20:39
Problem using Graphics with multiple Threads [Java] Recognize hdmi screen without restarting the pc