Ryan, thanks. this way is very simple, and the best of not need calendar.
thanks. On 13 jan, 23:56, Ryan How <[email protected]> wrote: > Looks good to me. If it works and does what you need. > > Or you could try something like > > SELECT * FROM persons WHERE FORMATDATETIME(born, "DD MM") = > FORMATDATETIME(CURRENT_DATE, "DD MM") then you could skip putting in any > parameters. > > On 14/01/2012 12:48 AM, the nigga wrote: > > > > > > > > > I could do what needed. I do not know if it's the best way but worked. > > > here how I did. > > > public List<Persons> getPersonsBirthday(){ > > // return a list of all persons birthdays today > > List<Persons> lista = new ArrayList<Persons>(); > > GregorianCalendar cal = new GregorianCalendar(); > > int day = cal.get(cal.DAY_OF_MONTH); > > int month = cal.get(cal.MONTH) + 1; > > try { > > PreparedStatement stm = this.con.prepareStatement("SELECT > > * FROM persons WHERE DAYOFMONTH(born) = ? AND MONTH(born) = ?"); > > stm.setInt(1,day); > > stm.setInt(2, month); > > ResultSet rs = stm.executeQuery(); > > while(rs.next()){ > > Persons person = new Persons(); > > person.setBorn(rs.getString("born")); > > lista.add(person); > > } > > rs.close(); > > stm.close(); > > } catch (SQLException ex) { > > > Logger.getLogger(PersonsDAO.class.getName()).log(Level.SEVERE, null, > > ex); > > } > > return lista; > > } > > > That's worked. there another way to do that ? > > > thanks. > > > On 13 jan, 10:58, Ryan How<[email protected]> wrote: > >> Do you want the date of their next birthday? > > >> An example of the output you want would be helpful. > > >> On 13/01/2012 12:19 PM, the nigga wrote: > > >>> Hello > >>> I have a field in my table persons: BORN DATE. > >>> how can I get a birthday of a person through a SELECT ? > >>> I am trying do this using Calendar,but not work. > >>> thanks. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
