By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE Details (
TourCompletionDateTime VARCHAR NOT NULL,
TourID VARCHAR NOT NULL,
PRIMARY KEY (TourID)
);
✓
INSERT INTO Details (TourCompletionDateTime, TourID)
SELECT '2022-07-26T09:36:00.730589Z', 'tour541'
WHERE EXISTS (
SELECT 1
FROM Details
WHERE TourCompletionDateTime < '2022-07-26T09:36:00.730589Z'
)
OR NOT EXISTS (SELECT * FROM Details);
✓
SELECT * FROM Details;
TourCompletionDateTime |
TourID |
|---|---|
2022-07-26T09:36:00.730589Z |
tour541 |