Query Studio changing string timestamp value (looks fine in FM)

[AndyAddison]

Hi All,

I'm working with Cognos v10.1.1, Oracle Data Source

I'm seeing a strange behaviour when creating a simple report pulling through a text field and struggling to work out what's happening!

I have an oracle view that formats a date into a character using to_char(datattrib,'YYYY-MM-DD HH24:MI:SS') - so the output looks something like '2014-02-12 13:53:28'. The view attribute is listed as varchar2(19)

Mapped to the view into Framework Manager - tested and see '2014-02-12 13:53:28'

However, when I create my report in query studio it displays '2014-02-12 01:53:28'

Furthermore when I then try to reformat as a date and format using the 24 hour clock (and for fun adding AM/PM) query studio presents it as '2014-02-12 01:53:28 AM'

I have tried bringing through the "real" date and get the same behaviour.

I'm confused as to why Framework Manager displays everything perfectly, but Query Studio in a simple list of the same table is modifying the data!

Any ideas are gratefully received.

Andy

[MFGF]

Hi,

It sounds very much like the item is being handled as a date within your model. When you test things from within FM, date formats are not applied to the test result set, even if defined in the model. They are applies when you use a studio to report on the data from a published package, though.

If your item in FM is a date (rather than varchar) try setting the date format you want to see and republishing your package.

Cheers!

MF.