01.String sql = "SELECT Employee.E_StartDate, Employee.Status_Id, DATEDIFF('y', [E_StartDate], ' 2013-08-30' ) AS dayofyear from Employee order by Employee.E_Code ASC";
02. try{
03. pst = conn.prepareStatement(sql);
04. rs = pst.executeQuery();
05. while(rs.next()){
06. int dayy = rs.getInt("dayofyear");
07. }catch(){
08. JOptionPane.showMessageDialog(null, e);
09. }
จัดไปครับ
