$sqlquery = "select * from event where (event_userid = '$pemlogin->mail_id') AND ( (event_date = '$query_date') OR ";
$sqlquery .= " (TO_DAYS(event_date) <= TO_DAYS('$query_date')) AND ";
$sqlquery .= " ( (event_repeat = 1) OR ";
$sqlquery .= " (event_repeat = 2 AND WEEKDAY(event_date) = WEEKDAY('$query_date')) OR ";
$sqlquery .= " (event_repeat = 3 AND DATE_FORMAT(event_date, '%d') = DATE_FORMAT('$query_date', '%d')) OR ";
$sqlquery .= " (event_repeat = 4 AND DATE_FORMAT(event_date, '%m-%d') = DATE_FORMAT('$query_date', '%m-%d'))";
$sqlquery .= " ) ) ";
$sqlquery .= " order by event_starttime asc, event_duration desc";
위와 같은 구문이 있는데요..이건 매일, 주별, 년별로 메세지를 보내주는 sql커리문입니다... 근데 이걸 오라클용으로 바꿀려면..어떻게 해야할까요..
weekday라든지..포맷형식이라는지..어떻게 해야하는지..부탁드립니다..
제가 너무 급해서요...
|