Hello everyone.
i m using XSLT to convert one xml to other.
when i pick dates from xml it was like 9/9/2005 12:00:00 AM
But when i translated it using XSLT then the result was like 2008-01-18T14:41:21-08:00.
which returns error when saving into database.
so want to convert date time from 2008-01-18T14:41:21-08:00 to 9/9/2005 12:00:00 AM format.

Regards
navi

In XSLT 2.0 you can use the format-date() function, in 1.0 you'll need to use low-level string manipulation (substring, concat, etc). You might find a library routine to do it at www.exslt.org.

Incidentally if you're going to illustrate your required format by example, then choose an example that isn't ambiguous - we can't tell whether 9/9/2005 is d/m/y or m/d/y.

Michael Kay
http://www.saxonica.com/
Author, XSLT 2.0 and XPath 2.0 Programmer's Reference

i m using XSLT 1.0
format-date() doesnt work??
any other alternate

I gave you several alternatives in my original reply.

(a) use XSLT 2.0

(b) use the EXSLT date/time library at www.exslt.org

(c) use low-level string manipulation (concat, substring, etc)

Michael Kay
http://www.saxonica.com/
Author, XSLT 2.0 and XPath 2.0 Programmer's Reference