AND DATE_FORMAT(OI.CREATED_DATE, '%Y%m%d%H')
<choose>
<when test="(searchStartDateTime != null and searchStartDateTime != '') and (searchEndDateTime != null and searchEndDateTime != '')">
BETWEEN CONCAT(#{searchStartDate},#{searchStartDateTime}) AND CONCAT(#{searchEndDate},#{searchEndDateTime})
</when>
<otherwise>
BETWEEN #{searchStartDate} AND #{searchEndDate}
</otherwise>
</choose>
</if>
À§¿Í °°ÀÌ ÇÏ¸é ¿¡·¯°¡ ¹ß»ýÇÏÁö ¾Ê´Âµ¥
<if test="searchDateType == 'OICD'">
AND DATE_FORMAT(OI.CREATED_DATE, '%Y%m%d%H')
</if>
<choose>
<when test="(searchStartDateTime != null and searchStartDateTime != '') and (searchEndDateTime != null and searchEndDateTime != '')">
BETWEEN CONCAT(#{searchStartDate},#{searchStartDateTime}) AND CONCAT(#{searchEndDate},#{searchEndDateTime})
</when>
<otherwise>
BETWEEN #{searchStartDate} AND #{searchEndDate}
</otherwise>
</choose>
ÀÌ·¸°Ô À§¿Í °°ÀÌ ÇÏ¸é ¿¡·¯°¡ ¹ß»ýÇÕ´Ï´Ù.
type ¿¡ µû¶ó DATE_FORMAT ¿¡ µé¾î°¡´Â Ä÷³¸¸ ÁöÁ¤ÇØÁÖ°í ½ÍÀºµ¥ ¿¡·¯°¡ ¹ß»ýÇÏ´Ï È¤½Ã ¾î¶²½ÄÀ¸·Î Çϸé ÁÁÀ»Áö Á¶¾ð ºÎŹ µå¸³´Ï´Ù.
CHOOSE ¿µ¿ªÀº Çϳª¹® µÎ°í Ä÷³ ¹Ù²î´Â ºÎºÐ¸¸ ºÐ±âó¸® ÇÏ·Á°í Çϴµ¥ ¾ÈµÇ³×¿ä ¤Ì_¤Ì
¿À¶óŬÀº µÇ´Â°Å °°Àºµ¥..
Áú¹® | 1862¸íÀÌ Àоú¾î¿ä. 18.188.135.236