SLTechnology News&Howtos › Database ›

DB2 takes the natural days of the specified range

Shulou Source: shulou.com Published: 2022-06-01 16:01:34 10月04日 Update

Oracle:

(Select to_char (axi1meric IDD) SHOW_TIME From (

SELECT rownum Id,to_date (# {endDate,jdbcType=VARCHAR}, 'YYYYMMDD') a FROM DUAL

CONNECT BY LEVEL