33、 MAKETIME(hour ,minute ,second ):根據(jù)參數(shù)(時(shí),分,秒)獲取時(shí)間 1 SELECT MAKETIME(12 ,23 ,34 ) 1 -> 12:23:34 34、YEARWEEK(date):獲取日期的年和周 1 2 3 SELECT YEARWEEK(SYSDATE()) SELECT YEARWEEK(‘2015-01-10') SELECT YEARWEEK(‘2015-01-10',1) 1 2 3 -> 201602 ->...
www.dbjr.com.cn/article/1358...htm 2025-6-2