From DateTime to Date in XQuery
Submitted by Hugo Hendriks on Wed, 20/07/2011 - 13:36
When you create a database adapter using JDeveloper, the Date fields in the database will be modelled as DateTime fields in the xsd. Often you will only want Date fields.
A simple way to convert the DateTime fields to Date fields using XQuery is like this:
<ns3:Geboortedatum>{ data(xs:date(substring-before($pollSfStudentoplCollection1/ns4:PollSfStudentopl[1]/ns4:geboortedatum/text(),'T'))) }</ns3:Geboortedatum>

