majstor wrote: > Hello, > > I have an sql statement which is don't work: > > SELECT CAST(CURRENT_TIME AS VARCHAR(10)) FROM RDB$DATABASE > > maybe I'm craisy, but what is wrong???
SELECT SUBSTRING ( CURRENT_TIME from 1 for 10 ) FROM RDB$DATABASE CURRENT_TIME is 13 characters long and CAST does not know how to trim it. I'm normally just trimming to 5 characters to loose the seconds ;) -- Lester Caine - G8HFL ----------------------------- Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk EnquirySolve - http://enquirysolve.com/ Model Engineers Digital Workshop - http://medw.co.uk Rainbow Digital Media - http://rainbowdigitalmedia.co.uk
