Oracle视图时间戳转为Date

最新推荐文章于 2022-04-20 16:08:58 发布

转载最新推荐文章于 2022-04-20 16:08:58 发布 · 287 阅读

文章标签：

#数据库

本文介绍了一个用于创建PDA订单视图的SQL语句，该视图从Pda_Order表中选择订单ID、订单号、金额等字段，并通过关联Pda_Order表获取订单的开始时间和结束时间。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

 CREATE OR REPLACE VIEW PDAORDER AS
SELECT 
po.id id,
po.order_no AS order_no,
po.money AS money,
  (SELECT TO_CHAR(t.starttime / (1000 * 60 * 60 * 24) +  
       TO_DATE('1970-01-01', 'YYYY-MM-DD'), 'YYYY-MM-DD') as starttime
         FROM Pda_Order t
        WHERE t.id = po.id) AS starttime,
   (SELECT TO_CHAR(t.endtime / (1000 * 60 * 60 * 24) +  
       TO_DATE('1970-01-01', 'YYYY-MM-DD'), 'YYYY-MM-DD') as endtime
         FROM Pda_Order t
        WHERE t.id = po.id) AS endtime,
po.userno as userno,
po.bowei as bowei,
po.carno as carno,
po.status as status,
po.img as img       
FROM Pda_Order po