XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Show tree view Topic
Topic Page 1 2 3 4 5 6 7 8 9 Go to previous topicPrev TopicGo to next topicNext Topic
Postnext
Tony LavinioSubject: Convert date
Author: Tony Lavinio
Date: 25 Jul 2005 03:03 PM
How are you getting the date out of the database?

If the string were in an XML document or equivalent already, the
expression would be something like:

substring-before(substring-after(substring-after(., '/'), '/'), ' ')

Or, if you knew that the mm and dd were always going to be two digits,
you could use
substring(., 7, 4)

Replace the '.' in the above with the expression that resolves to the
node containing the date.

Postnext
Sravan kothaSubject: Convert date
Author: Sravan kotha
Date: 25 Jul 2005 05:39 PM
Hi Tony,

I have a text field for date in one module and a date field in other module. When i enter the yyyy in text field it is stored in database as 2005 but when i enter it from date field it is stored as 1/1/2005 00:00. The code u have sent to me works when i copy the date from date field to text field in my application but not from text to date field. Can u please help me out.

Thanks

Posttop
Tony LavinioSubject: Convert date
Author: Tony Lavinio
Date: 26 Jul 2005 10:43 AM
I'm not quite sure why the first form I gave you before wasn't
working; perhaps you could tell me what you did get for output
from it?

You could also try this:
substring(substring-after(substring-after(., '/'), '/'), 1, 4)

That will get the first four characters after the second slash.

 
Topic Page 1 2 3 4 5 6 7 8 9 Go to previous topicPrev TopicGo to next topicNext Topic
Download A Free Trial of Stylus Studio 6 XML Professional Edition Today! Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!  
go

Log In Options

Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.