INSERT INTO
base_userandorganize(createdate)
values(to_date(to_char(sysdate,'yyyy-mm-dd'),'yyyy-mm-dd'))
select to_char(t.checkdate,'YYYY-MM-DD HH-mi-SS') as checkdate
from userinfo
where checkdate between to_date(#startDate#,'YYYY-MM-DD HH24-mi-SS')
and to_date(#endDate#,'YYYY-MM-DD HH24-mi-SS')