날짜 쿼리(2주후 까지 찾기)

select a.*, b.name as b_name
  from 테이블 as a left join member as b on a.input_id=b.id
   where a.delete='n' and a.cat='company'  and a.input_id='아이디'  and (case 
      when
       length(a.c_birth)=10
      then
       a.c_birth::text::date between current_date and (current_date + '2 week'::interval)::date
      when
       a.c_birth is null
      then
       false
      else
       false
      end
     )  order by a.reg_date desc
  limit 20 offset 0


c_birth 을 varchar 형으로 놓아서 date 타입 검색이 어렵다.
그래서 형변환......