CODE EXAMPLE FOR CPP

split date and time in a column in db browser

SELECT
    date(d1),
    time(d1)
FROM
    date_n_time;