How To Calculate Date and Time in Different Column ?

Question

Question

Steven Henry Su... · Jun 11

#SQL #InterSystems IRIS #Other

Hy Friends,

I need some help, how to calculate date and time in different columns ?

Does Anyone could help me ?

Thank you

Best Regards,

Steven Henry

Discussion (8)1

Log in or sign up to continue

Manel Trèmols · Jun 12

Hi Steven,

You can user the CONCAT function

select OEORI_Date, OEORI_TimeOrd, OEORI_UpdateDate, OEORI_UpdateTime, DATEDIFF('n',{fn CONCAT({fn CONCAT(OEORI_Date,',')},OEORI_TimeOrd)},{fn CONCAT({fn CONCAT(OEORI_UpdateDate,',')},OEORI_UpdateTime)}) from SQLUser.OE_orditem

2 0

Oliver Thompson · Jun 13

Thanks for the clarification.

The answers from @Manel Trèmols and @Ramil TK should both work for you.

You might have to do some additional formatting depending on what datePart you getting the difference in. For example if you get the difference in Minutes ("n"), then you will have to convert that into Days, Hours, Minutes etc, so it will depend on what you are expecting in the data and how big those differences might be.

0 0

score 2 · Answer 1 · 2024-06-11T10:02:39-04:00

Can you clarify what you are trying to do please?

Are you trying to calculate the difference between the 2 dates/times? If that is the case have a look at the DATEDIFF(..) SQL functions.
https://docs.intersystems.com/iris20241/csp/docbook/Doc.View.cls?KEY=RSQ...

score 0 · Answer 2 · 2024-06-11T22:28:24-04:00

Hy @Oliver Thompson

Sure, I'm trying to calculate the difference between the 2 dates/times, but the problem is, it has a different columns (date and time), so does it mean that I've to combine it into 1 columns (Ex: DateTimeorder ->combine Date and Time Order, and DateTimeUpdate -> combine date update and time update) then calculate them or any other way to do it ?

Thank You

Steven Henry