[SQL] convert time

Is there a way for postgres to output using the 12 hour standard instead of army time? The column is of type time ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMA

[SQL] SQL output

CREATE TABLE tablename (field INTERVAL); INSERT INTO tablename VALUES('3 weeks'); SELECT field FROM tablename; _ | field | |--| | 21 days | || The output shows up in days or months but not weeks how do i make it output in weeks? Any help with this wi