0

Is there anyway to join 3 columns to create a new column with the date value

I have a column name Month Day Year and I need to join them and show the date result of the values form those columns enter image description here

skaailet
  • 41
  • 3
  • `void QDate::getDate(int *year, int *month, int *day) const` looks promissing..... (see: https://doc.qt.io/qt-5/qdate.html#getDate ) – Luuk Jun 18 '20 at 18:56

1 Answers1

1

Here is a solution using concatenation and casting:

SELECT CAST(CONCAT(dia, '-', mes, '-', ano) AS Date)
FROM s
Chris
  • 145
  • 8