how to create new date from 3 columns in SQL

Question

i've got columns with year, month and day. how can i put together in SQL? SELECT DATA, year(data) AS "ROK", (month(data)+1) AS "MIESIAC", day(data) AS "DZIEN" FROM ZAMOWIENIA JavaScript questions and answers, JavaScript questions pdf, JavaScript question bank, JavaScript questions and answers pdf, mcq on JavaScript pdf, JavaScript questions and solutions, JavaScript mcq Test , Interview JavaScript questions, JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)

Answer 1

The syntax will depend on your flavor of SQL, but looking at your code I think the simplest solution is to add a month to the data column: SELECT DATA, DATEADD(month, 1, data) FROM Table