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?