go to post Ramil TK · Jun 13 You can able to do like this also. select OEORI_Date, OEORI_TimeOrd, OEORI_UpdateDate, OEORI_UpdateTime, datediff('n',%EXTERNAL OEORI_Date||' '||%EXTERNAL OEORI_TimeOrd,%EXTERNAL OEORI_UpdateDate||' '||%EXTERNAL OEORI_UpdateTime) from SQLUser.OE_orditem
go to post Ramil TK · Aug 10, 2023 me is using this line to get this w $ZSTRIP($ZD($NOW(),1,,),"*","/"),!
go to post Ramil TK · Sep 22, 2022 Thanks for the great article...This article help me more points need to be check while create dashboards and drilldown in PBI.
go to post Ramil TK · Aug 16, 2022 All the Major Learning points in one shot....Great... Thanks a lot @Yuri Marx
go to post Ramil TK · Aug 16, 2022 I think this error showing reason is you are not installed the odbc driver of Cache DB. Please try to download it and install it, after that please try. Download Locations https://github.com/intersystems-community/iris-driver-distribution/tree/main/ODBC Caché ODBC drivers are located here: ftp://ftp.intersystems.com/pub/cache/odbc/ InterSystems IRIS ODBC drivers -- here: ftp://ftp.intersystems.com/pub/iris/odbc/
go to post Ramil TK · Aug 4, 2022 Thank you, and one more question in this. How we can format the date string like DD/MM/YYYY HH:MM:SS like this or any other format
go to post Ramil TK · Aug 4, 2022 @Yaron Munz Thanks for the response. Did you try with Laravel and succeed the connection? if success can you able to help me out?
go to post Ramil TK · Aug 4, 2022 Thank you for your replay and this one also working fine. This is already using one solution in that date and time are in a separate columns.
go to post Ramil TK · Aug 4, 2022 select ROUND((date(NOW()) - date(DOB)) / 365,0) age,date(NOW()) from user Using the above query me solved the point no 2 and 3, but point no 1 still i don't get any solution. If any correction or suggestion in above query please correct me. @Yaron Munz @Robert Cemper @Eduard Lebedyuk
go to post Ramil TK · Aug 4, 2022 1)I am trying to Concatenate the 2 columns together, like bill date is in one column and bill time is in another column. I want to combine this both column and need to display as date and time using query. 2) I am trying to get all the above using sql query.
go to post Ramil TK · Jul 30, 2022 Great to hear. But this kind of option is still not found in the live areas, I think so.
go to post Ramil TK · Jul 28, 2022 Can you able to share the Git Link of Laravel project connected to Intersystem.