This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
How do I get Alteryx to add time & seconds?
Field one has a start time (Excel Format- H:MM:SS AM/PM)
Field two has a duration in seconds. (Excel format- SSS)
Is it possible to get this solution in Alteryx?
Go to Solution.
Go to Solution.
Generally, we would think an expression like:
DateTimeAdd([Start Time],[Duration (Sec)],"seconds")
would be what you are looking for, but that will error out if [Start Time] is a Time data type.
We need to first to make it look like a DateTime data type, and then we can use the DateTimeAdd() function. Something like:
DateTimeAdd(DateTimeToday()+" "+[Start Time],[Duration (Sec)],"seconds")
works in the attached, and notice the data type of the output column is Time in the attached.
As long as a string is in the Alteryx DateTime format "%Y-%m-%d %H:%M:%S", Alteryx can use it as a DateTime data type.
Exactly what I needed!
I need to evaluate a time between times... Basically look at: AND TO_DATE ('0001-01-01 ' || MBCM.ENTRY_TM,'YYYY-MM-DD HH24.MI.SS') BETWEEN TO_DATE ('0001-01-01 '|| OGWP.CRTE_TM,'YYYY-MM-DD HH24.MI.SS')- INTERVAL '59' SECONDAND TO_DATE ('0001-01-01 '|| OGWP.CRTE_TM,'YYYY-MM-DD HH24.MI.SS')+ INTERVAL '59' SECOND
This works in oracle in TOAD but not in alteryx. How can evaluate if a time stamp in one table falls between another time in another table with a 59 second interval?