Sorry, I forgot to answer your question about using other Sqlite
built-in functions for date and time. I need my own custom version
because my database dates can be stored as either a double value (OLE
Date scheme) or as text representation. My custom functions can also
accept a format template allowing great flexibility as to the
formatted output.
But aside from that, if this is a Sqlite bug, we need to get it
fixed anyway.
cheers
-brett
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
> [email protected]
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>
----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
