subject:"\[SQL\] timespan casting"

Re: [SQL] timespan casting

2000-06-22 Thread Ed Loehr

Jeff MacDonald wrote: > bignose=> select start,stop, stop-start as start_stop from foo; > start | stop | start_stop > ++ > 2000-06-22 20:37:12-03 | 2000-06-22 20:37:12-03 | 00:000 > > now my question.

[SQL] timespan casting

2000-06-22 Thread Jeff MacDonald

hi, thought this up while playing with time spans.. here is my table and data.. bignose=> \d foo Table "foo" Attribute | Type| Modifier ---+---+-- start | timestamp | stop | timestamp | bignose=> select start,stop, stop-start as start_sto