Quoting Simon Law <[EMAIL PROTECTED]>:
>
> CREATE TABLE tablename (field INTERVAL);
> INSERT INTO tablename VALUES('3 weeks');
> SELECT field FROM tablename;
> | 21 days |
>
> The output shows up in days or months but not weeks how do i make
Internally, INTERVAL is stored as a 12byte tuple
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
