[sqlite] Can't get concat operator to work

[brettg]

  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.

  Can someone *please* check into this.  I must get this working.

  Thank you
-brett

  

----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users