Posts by Jean Mayer • 31 points

• 2

  votes

  1

  answer

  5358

  views

  A: How to select a date in the dd/mm/yyyy format in mysql?

  I was doing it the wrong way. I ended up trying it again and it worked. SELECT DATE_FORMAT(STR_TO_DATE('campo', '%Y-%m-%d'), '%d/%m/%Y') FROM 'tabela'

  mysql sql

  answered 7 years, 6 months ago Jean Mayer 31

• 1

  votes

  1

  answer

  5358

  views

  Q: How to select a date in the dd/mm/yyyy format in mysql?

  Good morning/late/evening I need to select a field TYPE DATE in mysql, the data is in the format yyyy-mm-dd, I need you to come back dd/mm/yyyy. Is there any way to do this in select? I’ve seen…

  mysql sql

  asked 7 years, 6 months ago Jean Mayer 31