How can I convert

From = 2024-07-04 13:21:16.477

To = 20240704132116

Hey Community,

"Wonders of the World" journey on Global Masters is over - thank all for participating! Now it's time to announce the Raffle Winner!

🎉🎉🎉 Congratulations to @Goran Trbojević - the winner of the Nike Backpack! 🎉🎉🎉

His entry was randomly selected among 16 participants who completed ALL the challenges in the "Wonders of the World" campaign.

And one of the challenges was to 📸 upload a selfie with one or two words that you associate with InterSystems.
Just look at these exciting photos!
Your words for us are SO inspiring!
Thank you all who gave us your permission to share your photo on DC and social media:

At hackathons that InterSystems participated and I supported, many students were asking how all their teammates could use the same IRIS database that they spun up in a container. I suggested using ngrok to expose their localhost IRIS and realized we don't have documentation on that. Hence, I thought this would be great to let more people knwo about this powerful technique for enhancing collaboration during development and testing.

If you're migrating from Oracle to InterSystems IRIS—like many of my customers—you may run into Oracle-specific SQL patterns that need translation.

Take this example:

SELECT (TO_DATE('2023-05-12','YYYY-MM-DD') - LEVEL + 1) AS gap_date
FROM dual
CONNECT BY LEVEL <= (TO_DATE('2023-05-12','YYYY-MM-DD') - TO_DATE('2023-05-02','YYYY-MM-DD') + 1);

In Oracle:

Hi.

How can I prevent the error:

2024-12-27 08:05:46 [SQLCODE: <-400>:<Fatal error occurred>] [Error: <<READ>XDCall+9^%SYS.DBSRV>] [Location: <$system.IO server loop>] [Client info: <Username: Operator, Node Name: PM_MIP_SRD01, IP Address: 10.40.1.108, Executable Name: Operative.dll, Internal Function: KÂ>] [%protocol: <65>] $Id: //iris/2023.2.0/kernel/common/src/sysio.c#2 $ 3514 121

It seems that this error occours when connection on PDA is lost and established again.

Tnx.

Regards,
Matjaž

I am experiencing an issue while executing a stored procedure in InterSystems Cache. Here’s the procedure I created

CREATE PROCEDURE Silk.sp_InsertRecord (
IN RecordDate TIMESTAMP,
IN UserName VARCHAR(50),
IN RecordType INT,
IN RecordID VARCHAR(50),
IN CategoryID INT,
IN ApprovalDate TIMESTAMP,
IN FileSize BIGINT,
IN WorkstationName VARCHAR(50)
)
BEGIN
INSERT INTO DummyRecords (
RecordKey,
FilePath,
RecordDate,
UserName,

Hey,

I'm testing a REST API that is used for our IRIS Backend with a mobile app (Angular / ionic).

The problem is that, our test environment does not yet have HTTPS capabilities, it's something we're going to set up ASAP, but right now we don't have it set up.

We want to test the API endpoints via a web browser using either a test application built in Angular, or the app itself built with NPM via the browser. This means that the set-cookie headers are being blocked by the browser.

Hi Community,

Watch this video to learn how to use HL7® FHIR® Shorthand (a domain-specific, human-readable language for defining profiles, extensions, and other FHIR artifacts) to more efficiently create a FHIR Implementation Guide:

⏯ Using HL7 FHIR Shorthand

https://www.youtube.com/embed/vr58My_qL6E
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

Hi all,

As part of the InterSystems Solutionathon we would like to distribute a very quick survey on your thoughts on using AI-driven code documentation for ObjectScript.

https://forms.office.com/r/nSGevGpbTy

Please let us know if you have any further questions!

Hey Developers,

Here is a digest of the Developer Community videos on InterSystems Developers YouTube Channel in July 2020:

This great article sparked some recent private discussion, and I'd like to share some of my own thoughts from it.

The motivating concern boils down to: Why do we need coding rules or conventions at all? What happened to the wonderful era of the Renaissance artist-programmer forging their own path, prior to being supplanted by the craftsman and now (even worse) by AI?

I have a local testing environment using VSCode.

I'm trying to create a routine %Test.mac, but keep getting permission error.

I have enabled write permissions to percent globals in the Admin Portal.

I'm connecting to Iris with superuser.

How do I give myself permissions?

Thanks