<[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > I'm trying to get the concat operator to work with my user-defined > function. This works fine: > > SELECT UPPER(FirstName) || ' ' || UPPER(LastName) FROM Employees > > But this doesn't work: > > SELECT FORMAT_DATE(login_time) || ' ' || FORMAT_TIME(login_time) > FROM Sessions > > I get only the formatted date - missing the formatted time.
Does this work: SELECT '!' || FORMAT_TIME(login_time) || '!' FROM Sessions; In other words, are you sure FORMAT_TIME doesn't return an empty string, or a string consisting only of whitespace? Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
