string getDate(){ string date = to_string(dd)+"/"+to_string(mm)+"/"+to_string(yy); return date; code example

Example: sql to char function with date

SELECT
  TO_CHAR( sysdate, 'YYYY-MM-DD' )
FROM
  dual;