Question

How do I use to_date in Oracle to do this?

I tried inputting the date and time but only the date shows up.How do I also at 7 days to this date and change the time to 2 pm?

(SELECT TO_DATE('2019/05/19 04:00 PM', 'yyyy/mm/dd hh:mi AM') FROM dual),

GARAGE_CODE VUNIT_ID RESERVE_DA RENTER_NO
----------- ---------- ---------- ----------
12 451 19/05/2019 10

Answer 1

TO_DATE function convert string into date.

Your query is correct. It convert it into date and time as per your given format. But due to default format of date it only show you date. To see time you can use TO_CHAR method which return date and time as a string.

Use below sql:

SELECT TO_CHAR(TO_DATE('2019/05/19 04:00 PM', 'yyyy/mm/dd hh:mi AM'), 'yyyy/mm/dd hh:mi AM') FROM dual;

Syntax of TO_CHAR:

TO_CHAR(value [, format] [,language]

value: date or number which converted into string

format: Optional. format in which converted

language: Optional. language in which converted

To increase date simple + (add) number after TO_DATE.

To modify time use interval '2' hour [You can use minute at the place of hour for decrease minute] after TO_DATE.

Complete query is:

SELECT TO_CHAR(TO_DATE('2019/05/19 04:00 PM', 'yyyy/mm/dd hh:mi AM') + 7 - interval '2' hour, 'yyyy/mm/dd hh:mi AM') FROM dual;

Screenshot is given below:

Autocommit Display 10 SELECT TO_CHAR (TO_DATE ('2019/05/19 04:00 PM', 'y/mm/ dd hh:mi AM')'y/mm/dd hhimi AM") FROM dual: Results Explai Describe Saved SQL History TO_CHAR(TO DATE('2019/05/1904:00PM','YYYYIMM/DDHH:MIAM), 'YYYY/MM/DDHH:MIAM') 2019/05/19 04:00 PM 1 rows returned in 0.00 seconds CSVExport

Autocommit Display 10 SELECT TO CHAR (TO DATE ('2019/05/19 04:00 PM., .XXyX/mm/dd + 7 .XXyy/mm/dd hh:mi AM') - interval ·2' hour, hh : mi AM.) FROM dual; Results Explan Describe Saved SQL History TO_CHAR(TO DATE('2019/05/1904:00PM', YYYY/MM/DDHH:MIAM')+7-INTERVAL'2 HOUR, YYYY/MM/DDHH:MIAM) 2019/05/26 02:00 PM