assignment 3 problem SQL

OneLearn Course SQL
#1

image
image1920×1080 348 KB

how i convert time column into timestamp

#2 
SELECT incidnt_num,
       (SUBSTR(date, 7, 4) || '-' || LEFT(date, 2) ||
        '-' || SUBSTR(date, 4, 2) || ' ' || time || ':00')::timestamp AS timestamp,
       (SUBSTR(date, 7, 4) || '-' || LEFT(date, 2) ||
        '-' || SUBSTR(date, 4, 2) || ' ' || time || ':00')::timestamp
        + INTERVAL '1 week' AS timestamp_plus_one_week
  FROM tutorial.sf_crime_incidents_2014_01