代码之家 › 专栏 › 技术社区 › Sook Lim

为什么甲骨文中只显示日期而不显示时间?

sql-timestamp to-char to-date oracle

0

Sook Lim · 技术社区 · 5 年前

我在reserve表中插入了一条记录,如下所示:

INSERT INTO reserve(garage_code, vunit_id, reserve_date_time_placed, renter_no)
SELECT *
FROM (SELECT vehicle_unit.garage_code, vehicle_unit.vunit_id
FROM vehicle_unit 
INNER JOIN garage ON vehicle_unit.garage_code=garage.garage_code
WHERE vehicle_insurance_id ='sports-ute-449-12b' AND garage_name= 'Melbourne Central VIC'),
(SELECT TO_DATE('2019/05/04 04:00 PM', 'yyyy/mm/dd hh:mi AM') FROM dual),
(SELECT renter_no FROM RENTER WHERE renter_fname='Van' AND renter_lname='DIESEL');

但是,只显示指定的日期,而不显示时间。我试过了

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

0 回复 | 直到 5 年前