Community Halloween is live until October 31st! Complete any 2 quick activities to earn the 2025 Community Halloween badge. Feeling brave? Check out the activities here
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

In-DB Case Stmt Oracle Server Adding Time to DateTime Field

capoley
6 - Meteoroid
‎11-22-2021 08:47 AM

I have created this expression to subtract one second from a datetime field In DB (Oracle Server)

capoley_0-1637598291305.png

This gives me an error message, so I tried this:

capoley_1-1637598365375.png

Which also gave me an error.

I am wondering what I am doing wrong with this formula.

Peace,

Labels:
Reply
0 Likes
0 REPLIES 0
Community Live Fifa Workshop
Labels
Top Solution Authors
View All