SELECT substring(CAST(CURRENT_TIME AS VARCHAR(13)) from 1 for 8) FROM RDB$DATABASE



________________________________
From: majstor <majstoru@...>
To: firebird-support@yahoogroups.com
Sent: Wednesday, August 21, 2013 4:32 PM
Subject: [firebird-support] Converting CURRENT_TIME to VARCHAR



 
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???




[Non-text portions of this message have been removed]