get date from week number
Posted: Tue Feb 19, 2019 12:44 pm
Hello,
is there any possibility to get first and last day of a week number in XQuery ?
As input I have date formatted CCYYWW and want to get CCYYMMDD - CCYYMMDD
I also thought about option to implement java calendar but I failed in using java.
Calendar cal = Calendar.getInstance();
cal.set(Calendar.WEEK_OF_YEAR, 23);
cal.set(Calendar.DAY_OF_WEEK, Calendar.MONDAY);
So if there is no XQuery function how can I use java calendar ?
Thanks for help.
Steffen
is there any possibility to get first and last day of a week number in XQuery ?
As input I have date formatted CCYYWW and want to get CCYYMMDD - CCYYMMDD
I also thought about option to implement java calendar but I failed in using java.
Calendar cal = Calendar.getInstance();
cal.set(Calendar.WEEK_OF_YEAR, 23);
cal.set(Calendar.DAY_OF_WEEK, Calendar.MONDAY);
So if there is no XQuery function how can I use java calendar ?
Thanks for help.
Steffen