title: How to add date or time to a column in JPA
body: <p>I have the following table in the database:</p>
  
  <pre><code>create table PERSON
  (
      PERSON_ID bigint auto_increment primary key,
      BIRTHDAY date null,
      GENDER varchar(255) null,
      IDENTIFICATION varchar(15) null,
      LAST_NAME varchar(50) not null,
      NAME varchar(60) not null,
      constraint UK_7vkwh3506i8iq0ijvqoewdciy unique (IDENTIFICATION)
  );
  </code></pre>
  
  <p>And I want to do the following SQL statement in JPA2</p>
  
  <pre><code>SELECT
    P.PERSON_ID,
    P.BIRTHDAY
  FROM PERSON P
  WHERE
    DATE_ADD(P.BIRTHDAY,
        INTERVAL (YEAR(CURDATE()) - YEAR(P.BIRTHDAY))
                 + IF(DAYOFYEAR(CURDATE()) &gt; DAYOFYEAR(P.BIRTHDAY), 1, 0) YEAR)
    BETWEEN
    DATE_ADD(CURDATE(), INTERVAL 1 DAY)
    AND
    DATE_ADD(CURDATE(), INTERVAL 7 DAY);
  </code></pre>
  
  <p>I can't find the way of using date_add SQL method and nest between the other SQL methods.</p>
  
  <p>I need some help please. :)</p>