> Thanks. this is really great help.
> 
> One more question: Is it possible with the jena functions + regex to get from
> "2015-10-14T11:50:34.583+02:00" to "2015-10-14T11:50:00" ?
> 
> I think this should be possible with a combination of your suggestions above
> (STRBEFORE) plus some means to replace the "two characters after the
> second colon with 00". However, I don't know, if it's possible to do that with
> REGEX?

I just figured: To get from "2015-10-14T11:50:34.583+02:00" to 
"2015-10-14T11:50:00" some sort of string concatenation could also be useful.

This works for me: CONCAT(SUBSTR(STR(afn:now()), 1, 17), '00') 

Thanks again and best,
Peter

Reply via email to