[SQL] SQL output

[Simon Law]

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 will be greatly appreciated

P.S.
Best postgresql book?


---(end of broadcast)---
TIP 4: Have you searched our list archives?

  http://archives.postgresql.org

[SQL] convert time

[Simon Law]

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 [EMAIL PROTECTED] so that your
  message can get through to the mailing list cleanly