oracle中得出出生日期(随机产生:1900年1月1日----至今)的语法?

Answer 1

SELECT TO_DATE
          (TRUNC
              (DBMS_RANDOM.VALUE
                          (TO_NUMBER (TO_CHAR (  SYSDATE
                                               - TRUNC (  SYSDATE
                                                        - TO_DATE
                                                                ('1900-01-01',
                                                                 'yyyy-mm-dd'
                                                                )
                                                       ),
                                               'J'
                                              )
                                     ),
                           TO_NUMBER (TO_CHAR (SYSDATE, 'J'))
                          )
              ),
           'J'
          )
  FROM DUAL;

追问

谢谢大神，不过好像有点不对，得出的结果怎么会有35年的呀？