Postgres Pro
Downloads
Home   >   mailing lists

Unable to convert xpath value to date - Mailing list pgsql-general

From saritha N
Subject Unable to convert xpath value to date
Date
Msg-id CAMj0Pyt=NmRZ3giNxwRZZ43q3g-JrAjXcecRvtQ39XsX=S0eRg@mail.gmail.com
Whole thread Raw
Responses Re: Unable to convert xpath value to date  (David Johnston <polobo@yahoo.com>)
List pgsql-general
Tree view
Hi,

I am getting an error while retrieving the values from xml and converting into date format 

when I execute this query
select history from KM_REL_FF_USR_DATA where    USERID  in   (53008) and SHARE_WORKING_GROUP =15683

output is
"<HISTORY TYPE="DATAENTRYTYPE" ><USERSUBMITEDDATA ID="1" ><DATAENTRYFIELDDATA ID="1" TYPE="DATAENTRYTYPE" ><DATA ID="1" CREATED-DATE="09-09-2013" CREATED-TIME="12:00:00 am(am)" MODIFIED-DATE="09-09-2013" MODIFIED-TIME="12:00:00 am(am)" > Enter what you want to achieve from this programme&#058;
 </DATA></DATAENTRYFIELDDATA></USERSUBMITEDDATA></HISTORY>"

from this I need to extract modified date and convert to date.I am using this below query.But while executing this query I am getting error

select to_date(xpath('//DATA/@MODIFIED-DATE',(select history from KM_REL_FF_USR_DATA where    USERID  in   (53008) and SHARE_WORKING_GROUP =15683))::text,'dd/mm/yyyy')

 ERROR:  invalid value "{0" for "dd"
 DETAIL:  Value must be an integer.

Please help me out to solve this issue.

Thanks & Regards,
Saritha

pgsql-general by date:

Previous
From: Jaime Casanova
Date:
Subject: Re: Postgres replication question :- One master 2 slaves 9.0.10
Next
From: Johann Spies
Date:
Subject: Whole record returned in stead of field