DataDeploy Not Returning Expected Results

jajtiii

I am creating an XML file with DD and it is doing something odd that I am thinking might be a quirk with DataDeploy.

I run the following query in something like SQL+ and it works exactly as expected :

select qa_instant_news.title, qa_content.body, qa_grid.dcrname
from qa_instant_news, qa_content, qa_grid
where qa_instant_news.EXPIREDATETIME > CURRENT_DATE AND
qa_instant_news.LAUNCHDATETIME < CURRENT_DATE

The key with this query is the comparison of the expired date, launch date and the CURRENT_DATE. When I run it from sql+, it compares down to the minute. But, when DataDeploy runs it, it ignores the hours and minutes, only comparing YYYY/MM/DD. To reiterate, the exact same query run in sql+ produces different results when run through DD.

Any help on this would be appreciated.

thx,

jones

Adam Stoller

Just a thought, reaching back into the dim recesses of my mind where I once used DataDeploy more frequently than I do today ... isn't there somewhere that you specify the data-format for date-fields in DataDeploy (or in <database> elements in DCTs)?

If so - did you specify the format down to the minute in that format string?



--fish
Senior Consultant, Quotient Inc.
http://www.quotient-inc.com