Thanks Tom. Yes, I have tried that. The function definitely
returns a valid string.
Quoting BareFeet :
> 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
>
>
----------------------------------------------------------------
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
