Date / Timestamp Issue

Teresa Modesta · Apr 12, 2018 8:15AM

Hello,

I have this problem where I have a timestamp in an analysis from a subject area dimension field that I convert to a date to do some date manipulation with.

This worked, but then after saving reloading etc it now errors with a conversion error after no changes at all.

Robert Angel · Apr 12, 2018 8:18AM

Hi,

I have seen this also.

The fix is to make sure you explicitly convert it (cast to...) and never rely on implicit conversion at any point.

I am not sure why this works initially, and then fails, but that is the fix.

Gianni Ceresa · Apr 12, 2018 8:18AM

Larry&#39;s Friday Girl wrote:it now errors with a conversion error

Hi,

Thanks for letting us know

In case it's a question, what's the question?

And you will have to post a bit more if you expect an answer ...

Things like the detailed error, the conversion used, the version etc.

Martin van Donselaar · Apr 12, 2018 8:21AM

We cannot help you unless you answer at least the following questions: What exactly did you try, What Is the exact error, which Obiee version do you use, ..

Teresa Modesta · Apr 12, 2018 9:18AM

Sorry, I'm a bad girl...

Your resident angel solved my problem, he was dead right, but I will follow the rules next time...

Oracle Analytics Cloud and Server

Welcome!

Quick Links

Categories

Date / Timestamp Issue

Welcome!

Answers

Welcome!