Hi Brett, > 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. > FORMAT_DATE is my own user-defined function that returns text data > type.
I know I'm stating the obvious, but have you tried?: SELECT FORMAT_TIME(login_time) FROM Sessions since that's the part that does seem to be working. If it's giving you a blank then it's your function, not the concat operator. What do your custom functions do? Have you looked at the date and time functions built into SQLite? I expect that they'll cater for what you're after directly. Tom BareFeet _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
