Yes, this works fine. I get three columns: login date, empty
column, login time
Quoting Stephen Oberholtzer :
> On Mon, Mar 10, 2008 at 7:36 PM, wrote:
>>
>>
>> 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
>
> What about this?
>
> SELECT FORMAT_DATE(login_time), ' ', FORMAT_TIME(login_time) FROM
Sessions
>
>
> That will make sure that FORMAT_DATE(login_time) is working
properly
>
> --
> -- Stevie-O
> Real programmers use COPY CON PROGRAM.EXE
> _______________________________________________
> 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
