I am getting a Date from my xml using xpathsnippet funciton and it returns the d

aneeshv over 11 years ago

I am getting a Date from my xml using xpathsnippet funciton and it returns the date as a TEXT field.

I want to convert it back to Date to insert it in the db.

todate() function does not seem to work for me since it returns an integer and not a date.

None of the other date functions take input as a text and give output as date..

Is there any such function?...

Discussion posts and replies are publicly visible

Parents

0 aneeshv over 11 years ago

The date that comes back from the xml as a TEXT is as follows:-

2013-03-14T00:44:04.000Z

Is this a problem with the date that the xml returns or is this a problem with the function?

The o/p of the todate function gives me..

Sep 20, 5838270

This does not seem to me as a valid date format?

And therefore the db insertion is rejected..
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 aneeshv over 11 years ago

The date that comes back from the xml as a TEXT is as follows:-

2013-03-14T00:44:04.000Z

Is this a problem with the date that the xml returns or is this a problem with the function?

The o/p of the todate function gives me..

Sep 20, 5838270

This does not seem to me as a valid date format?

And therefore the db insertion is rejected..
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data