cancel
Showing results for
Did you mean:

Adding Time and seconds / Converting Seconds to Time

SOLVED
Meteor

Question –

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)

Excel Solution-

1. Divide Duration (Sec)/86400
2. Convert the format to time
3. Add Start Time with Duration (Time)

Problem –

Is it possible to get this solution in Alteryx?

Sample –

 Field 1 Field 2 End Result Start Time Duration (Sec) End Time 9:00:00 300 9:05:00 9:05:00 60 9:06:00

Quasar

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.

Meteor

Exactly what I needed!

Thank you!

Highlighted
Meteoroid

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' SECOND
AND 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?