CREATE TABLE table_204_608 (id NUMBER, "name" CLOB, "elected party" CLOB, "constituency" CLOB, "elected date" CLOB, "military service" CLOB)

how long did bernard pilon serve in the canadian army ?
SELECT "military service" - "military service" FROM table_204_608 WHERE "name" = 'bernard pilon'
SELECT "military service" - "military service" FROM "table_204_608" WHERE "name" = 'bernard pilon'