timestamp에러

 

 

 

 timestamp 에러

 

 

 

date를 timestamp로 가져오기때문에 타입 변경해줘야함

 

 

 

dao에서 date를 tochar 이용해서 string으로 바꿔주기

	public List<BoardVO> boardList2(List<Object> param) {
		String sql = "select * from\r\n"
						+ "    (select rownum rn, board_no, title, content, to_char(b.reg_date,'yyyy.mm.dd') reg_date, name, cnt\r\n"
						+ "    from board b, member m\r\n"
						+ "    where b.mem_no=m.mem_no\r\n"
						+ "    and code_no=?\r\n"
						+ "    and state=1\r\n"
						+ "    order by board_no desc)\r\n"
						+ "where rn>=? and rn<=?";
		
		return jdbc.selectList(sql,param, BoardVO.class);
	}