datetimenotz / datetime types problem when aggregates are used

[Klaster]

Hi,

I have a problem, 

We have database DATE fields defined as "datetimenotz" - however when during workflow we are using functions like max() then result is converted to "datetime"

Later during steps like intersection we are getting messages about datatypes incompatibility.

Is any way to solve that problem ?

regards

[Deb_Tripathy]

May I know what data base you are using?

Have you tried converting both fields to datetime and check if the intersection is still working or not?

Cheers,

Deb

[Klaster]

I'm using Oracle,

well, I prefer to convert just those values which are generated by Adobe because the rest of database uses "datetimenotz" 

regards