Hi,
I'm using jackrabbit and I'm trying to execute a query in order to
retrieve 'users', registered in JCR, who have a birthdate corresponding
to the current date.
For example if a user was born on june the 30th, 1992 I want to compare
the user's birthdate with june the 30th (and without the year wich is
not important in this case). I have tried a lot of queries, but without
success.
Any idea on how to perform such a query?
Thanks a lot,
jb
This one works:
//[EMAIL PROTECTED] = '1992-06-30T14:36:24.292+01:00']
These do not work:
//user[substring(@birthDate, 1, 1) = '1']
//user[substring(fn:string(@birthDate), 1, 1) = '1']
//user[concat(substring(@birthDate, 6, 2), substring(@birthDate, 9, 2))
= '0630']
//user[fn:month-from-dateTime(@birthDate) = 6]
//user[fn:month-from-dateTime(./@birthDate/value()) = 6]
