select "EQP_ID",random()*100 AS "VAL",concat(CURRENT_DATE-floor((random()*25))::int,' ',make_time(floor((random()*12))::int,floor((random()*60))::int,floor((random()*60))::int)) AS "CREATE_TIME" from "RPT_EQP"
PGSQL随机日期和值
最新推荐文章于 2023-10-18 13:58:05 发布