datetimenotz / datetime types problem when aggregates are used | Community
Skip to main content
K
Klaster
Level 2
May 27, 2022
Question

datetimenotz / datetime types problem when aggregates are used

  • May 27, 2022
  • 1 reply
  • 1099 views

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

D
DebTr
Level 6
May 31, 2022

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

K
KlasterAuthor
Level 2
June 6, 2022

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

Terms & ConditionsAccessibility statement

Loading footer...