Re: SPL-Problem

In article <firschke.8.0012DA51@d243d666.sietec.de> firschke@d243d666.sietec.de writes: >From: firschke@d243d666.sietec.de >Subject: SPL-Problem >Date: Fri, 15 Dec 1995 10:23:00 UNDEFINED >hello, >how can I assign a variable of type "decimal(8,2)" the >value of a column/variable of type "interval hour to minute"? >Because I always get the Error -1260 ! >Bye, Michael Found a solution by myself. First assign it to a char-variable, then do some substring- operations, and finally put the result into a decimal-variable. But why there isn't an equivalent for MONTH or DAY in SQL, which gives me the hours or minutes which are in a time-variable??? Greetings from Berlin, Michael