Date Format in VC from Oracle Database

[Former Member]

Hi all,

I created one BI JDBC system to access table from Oracle. I have written one query using SQL Editor. That Query displays the Valid From date and Valid To date. If I test the data service it displays the date correctly what we have given . But whenever I run that model, it displays Jan 01,2000 instead of all date. What is the problem?

The Date format in oracle is YYYY-MM-DD HH:MM:SS.0 .Whether VC is support this format or not? Why it is taking Jan 01,2000?

Help me in this regard. How can I resolve my problem?

Thanks& Regards,

Hemalatha J

[Former Member]

hi

i think you have to change your web service interface, from Date to Time

so you can use time format function

holp it make help

good day