
/* Code Fragment 9.7 Reconstruct the PROJECTIONS table as of April 1, 1996. */

SELECT 	PROJECTION_ID, PROJECTION_NAME, PROJECTION_TYPE,
	SPHEROID_CODE, PROJECTION_UOM, ZONE_CODE
FROM P_TT
WHERE Start_Date <= '1996-04-01'
AND '1996-04-01' < Stop_Date
