SELECT substring(CAST(CURRENT_TIME AS VARCHAR(13)) from 1 for 8) FROM RDB$DATABASE
________________________________ From: majstor <[email protected]> To: [email protected] 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]
