Louis-David Mitterrand <[EMAIL PROTECTED]> writes: > By the way, is it normal that the "day" word doesn't appear in the interval? > auction=# select interval(now()::abstime::int4); > interval > ---------------------------- > 30 years 9 mons 3 15:42:09 > (1 row) Looks like a bug to me ... Thomas, do you agree? Curiously, it appears that the interval input converter will accept this with or without the 'days' keyword included. regards, tom lane
- [SQL] Convert from Seconds-Since-Epoch to Timestamp Webb Sprague
- Re: [SQL] Convert from Seconds-Since-Epoch to ... Jie Liang
- Re: [SQL] Convert from Seconds-Since-Epoch... Brian C. Doyle
- Re: [SQL] Convert from Seconds-Since-E... Jie Liang
- [SQL] missing "day(s)" i... Louis-David Mitterrand
- Tom Lane