Oracle 创建视图与使用函数转换时间戳方法。 |
发表者:admin分类:数据库2020-09-14 15:36:21 阅读[907] |
Oracle 创建视图与 使用函数转换时间戳方法。
CREATE OR REPLACE FORCE VIEW VIEW_SIM
(
SIM,
BILL_NUM,
EQUIP_TYPE,
POSITION_TYPE,
SIGN_STATE,
GOLD_STATE,
OPERATE_ID,
STARTTIME,
UPDATETIME
)
AS
SELECT t.sim,
t.bill_num,
t.equip_type,
t.position_type,
t.sign_state,
t.gold_state,
t.operate_id,
fun_utc2date (UTCDATE => t.starttime,
PATTERN => 'YYYY-MM-DD HH24:MI:SS')
AS starttime,
fun_utc2date (UTCDATE => t.updatetime,
PATTERN => 'YYYY-MM-DD HH24:MI:SS')
AS updatetime
FROM (SELECT *
FROM te_equip e) t;
CREATE OR REPLACE FORCE VIEW VIEW_SIM
(
SIM,
BILL_NUM,
EQUIP_TYPE,
POSITION_TYPE,
SIGN_STATE,
GOLD_STATE,
OPERATE_ID,
STARTTIME,
UPDATETIME
)
AS
SELECT t.sim,
t.bill_num,
t.equip_type,
t.position_type,
t.sign_state,
t.gold_state,
t.operate_id,
fun_utc2date (UTCDATE => t.starttime,
PATTERN => 'YYYY-MM-DD HH24:MI:SS')
AS starttime,
fun_utc2date (UTCDATE => t.updatetime,
PATTERN => 'YYYY-MM-DD HH24:MI:SS')
AS updatetime
FROM (SELECT *
FROM te_equip e) t;
转载请标明出处【Oracle 创建视图与使用函数转换时间戳方法。】。
《www.micoder.cc》
虚拟化云计算,系统运维,安全技术服务.
Tags: | [阅读全文...] |
最新评论