Problem with To_Char in query
Hi
I am using soapUI 4.5.1. I worte a query in which I want my date to be populated in 'yyyy-mm-dd' format'
I used query buider for this and the results windwow i am getting successful result but when I tried same query in datadource step it is returning me 0 rows.
Query is like -
Select MYID, to_char(My_DT) from DETAILS where MY_ID in (Select MYID from INFO where MY_NAME ='ARCHANA')
If I remove to_char from query it works fine and retunrs me row in datasource step result window but I need date in 'yyyy-mm-dd' format and the default soapUi format is defferfent.
Can anybody help on this?
I am using soapUI 4.5.1. I worte a query in which I want my date to be populated in 'yyyy-mm-dd' format'
I used query buider for this and the results windwow i am getting successful result but when I tried same query in datadource step it is returning me 0 rows.
Query is like -
Select MYID, to_char(My_DT) from DETAILS where MY_ID in (Select MYID from INFO where MY_NAME ='ARCHANA')
If I remove to_char from query it works fine and retunrs me row in datasource step result window but I need date in 'yyyy-mm-dd' format and the default soapUi format is defferfent.
Can anybody help on this?