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
We need to use the third party software like Dragon Mic.
Congrats to all the winners....
Awesome!
Congratulations to all the winners...
Congrats to all the winners....
me is using this line to get this
w $ZSTRIP($ZD($NOW(),1,,),"*","/"),!
Thanks for the great article...This article help me more points need to be check while create dashboards and drilldown in PBI.
All the Major Learning points in one shot....Great...
Thanks a lot @Yuri Marx
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/
Congrats for all the winners...
Thanks @Yaron Munz
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
@Yaron Munz Thanks for the response.
Did you try with Laravel and succeed the connection? if success can you able to help me out?
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.
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.
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.
Done
Great to hear.
But this kind of option is still not found in the live areas, I think so.
Can you able to share the Git Link of Laravel project connected to Intersystem.
OK Thanks
This means the iService team will be ready for training and support or this kind of requirement will only do by the trakcare team.
This is a very good option who need to read this content in their own regional language.
Great Initiative.
In this what kind of questions we can ask.
As a starter, I have already a lot of doubts are there, trying to learn using the learning portal also.