9 lines
433 B
Plaintext
9 lines
433 B
Plaintext
SELECT
|
|
mpe.snapshotprodmapsummary.product_type as "Product Type",
|
|
mpe.snapshotprodmapsummary.snapshot_number as "Snapshot Number",
|
|
mpe.snapshotprodmapsummary.versions as "Versions",
|
|
mpe.snapshotprodmapsummary.effective_date as "Effective Date",
|
|
mpe.snapshotprodmapsummary.expire_date as "Expire Date"
|
|
FROM mpe.snapshotprodmapsummary
|
|
WHERE snapshotprodmapsummary.expire_date > now() OR snapshotprodmapsummary.expire_date IS NULL
|