일정기간기준으로 노출되기
http://sir.co.kr/bbs/board.php?bo_table=g4_qa&wr_id=215620#c_215625
여기보시면 질문대로 답변대로 했는데요 안되요;;
select distinct wr_parent from g4_write_total where and wr_datetime <='2012-02-10'
1064 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and wr_datetime <='2012-02-10'' at line 1
error file : /gnuboard4/bbs/board.php
이런게 뜨네요;
sql버전문젠가요????
여기보시면 질문대로 답변대로 했는데요 안되요;;
select distinct wr_parent from g4_write_total where and wr_datetime <='2012-02-10'
1064 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and wr_datetime <='2012-02-10'' at line 1
error file : /gnuboard4/bbs/board.php
이런게 뜨네요;
sql버전문젠가요????
|
댓글을 작성하시려면 로그인이 필요합니다.
로그인
댓글 2개
(예: 2012-02-17 17:56:35 형식)
그런데 날짜크기비교를 10자리데이터로 하셨으니 에러가나는겁니다.
wr_datetime을 이렇게 감싸주세요.
left(wr_datetime,10)
요렇게요???