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
