Re: Sql time query

Dirk Schmidtpott wrote: } } Katelis, Bill wrote: } > } > } Hi Bill ! } } If I understand your problem right then the following SQL should solve your } problem: } } SELECT duration[1,2] * 3600 } + duration[4,5] * 60 } + duration[7,8] duration_in_secs } FROM table } WHERE event = 1 } } Hope this helps ! } } Cheers, } Dirk } } Dirk, this will produce an -305 error because duration is a datetime field and not a char,varchar,text or byte field. Regards Tolis -- +---------------------------------------------------------------------+ | V+K Relational Solutions email: tvarnas@compulink.gr | | Deligiorgi 26 tvarnas@orbit.de | | 546 42 Thessaloniki Voice: (30) 31 820270 | | Greece Fax: (30) 31 865463 | +---------------------------------------------------------------------+