type tp is table 用法 DECLARETYPETPISTABLEOFNUMBERINDEXBYBINARY_INTEGER;TYPEVSISTABLEOFVARCHAR2(100)INDEXBYBINARY_INTEGER;TYPEVDISTABLEOFAPPS.SYS_USER.CREATE_DATE%TYPE;VNTP... Other 2023-12-30 34 点赞 0 评论 51 浏览
常用sql函数 常用日期函数UNIX_TIMESTAMP:返回当前或指定时间的时间戳 SELECT UNIX_TIMESTAMP(‘2018-08-08 08:08:08’)SELECT UNIX_TIMESTAMP(‘2018/08/08 08/08/08’,‘yyyy/MM/dd HH/mm/ss’)from_unixtime:将时间戳转为日期格式SELECT FROM_UNIXTIME(1533715688);current_date:当前日期SELECT CURRENT_DATE();current hive 2023-12-24 58 点赞 0 评论 87 浏览