On 1/27/2012 12:09 PM, John Heim wrote:
I'm trying to create a function that formats a time in a standard way
('%H:%i'). But all I can seem to get back is null.
DROP TABLE IF EXISTS bogus_table;
CREATE TABLE IF NOT EXISTS bogus_table (
btime TIME
);
INSERT INTO bogus_table VALUES ('12:34:56');
I'm trying to create a function that formats a time in a standard way
('%H:%i'). But all I can seem to get back is null.
DROP TABLE IF EXISTS bogus_table;
CREATE TABLE IF NOT EXISTS bogus_table (
btime TIME
);
INSERT INTO bogus_table VALUES ('12:34:56');
DROP FUNCTION IF EXISTS bogus ;
DELIMIT
