My bad... I meant 'View Ticket Page' as in 'Admin->Tickets->View Ticket
Page'.
I guess, I cannot call sql directly from TH1, can I?
Cheers,
Jacek
2015-01-20 21:55 GMT+00:00 Stephan Beal <sgb...@googlemail.com>:
> On Tue, Jan 20, 2015 at 10:14 PM, Jacek Cała <jacek.c...@gmail.com> wrote:
>
>> Is there an easy way to show ticket's submission time? I see tkt_datetime
>> which is a special TH1 variable that refers to tkt_mtime field from the
>> table. In the table there's 'tkt_ctime' but including that in a report
>> shows a double value which is of little use for the end users.
>>
>
> That's a Julian Day time - simply use strftime in your report to convert
> it, e.g.:
>
> sqlite> select distinct strftime('%Y-%m-%d', mtime) from event order by
> mtime desc limit 3 ;
> 2014-12-18
> 2014-12-17
> 2014-12-16
>
> --
> ----- stephan beal
> http://wanderinghorse.net/home/stephan/
> http://gplus.to/sgbeal
> "Freedom is sloppy. But since tyranny's the only guaranteed byproduct of
> those who insist on a perfect world, freedom will have to do." -- Bigby Wolf
>
> _______________________________________________
> fossil-users mailing list
> fossil-users@lists.fossil-scm.org
> http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users
>
>
_______________________________________________
fossil-users mailing list
fossil-users@lists.fossil-scm.org
http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users
