XQuery current-dateTime() Function

The XQuery current-date time() function is used to return the current date and time.

XQuery current-dateTime() Example

Use the following XQuery expression to fetch the current date and time.

current-datetime.xqy:

  let $datetime := current-dateTime()  return  <results>     <datetime>{$datetime}</datetime>  </results>  

Create a Java based XQuery executor program to read the current-datetime.xqy, passes it to the XQuery expression processor, and executes the expression. After that the result will be displayed.

XQueryTester.java

  import java.io.File;  import java.io.FileInputStream;  import java.io.FileNotFoundException;  import java.io.InputStream;    import javax.xml.xquery.XQConnection;  import javax.xml.xquery.XQDataSource;  import javax.xml.xquery.XQException;  import javax.xml.xquery.XQPreparedExpression;  import javax.xml.xquery.XQResultSequence;    import com.saxonica.xqj.SaxonXQDataSource;    public class XQueryTester {     public static void main(String[] args){        try {           execute();        }                catch (FileNotFoundException e) {           e.printStackTrace();        }                catch (XQException e) {           e.printStackTrace();        }     }       private static void execute() throws FileNotFoundException, XQException{        InputStream inputStream = new FileInputStream(new File(“current-datetime.xqy”));        XQDataSource ds = new SaxonXQDataSource();        XQConnection conn = ds.getConnection();        XQPreparedExpression exp = conn.prepareExpression(inputStream);        XQResultSequence result = exp.executeQuery();         while (result.next()) {           System.out.println(result.getItemAsString(null));        }     }  }  

Execute XQuery against XML

Put the above both files to a same location. We put them on desktop in a folder name XQuery12. Compile XQueryTester.java using console. You must have JDK 1.5 or later installed on your computer and classpaths are configured.

Compile:

javac XQueryTester.java

Execute:

java XQueryTester

Output:

XQUERY Current date time function 1

The above example shows both date and time.

download this example

Next TopicXQuery If Then Else Statement

XQuery current-dateTime() Function

XQuery current-dateTime() Function

XQuery current-dateTime() Example

Execute XQuery against XML

HTML vs XML

YII Upgradation

You may also like