Hi
Examples working in sqlite:
1. SELECT due as 'date' from milestone
2. SELECT strftime('%Y-%m-%d',datetime(due, 'unixepoch'),'localtime') as due
from milestone
Cheers / Erik
On Tue, Apr 8, 2008 at 3:17 PM, rupert thurner <[EMAIL PROTECTED]>
wrote:
>
> somebody has an example how to output a date format out of the number
> stored in the milestone due date?
>
> SELECT t.* FROM ticket t, m.due
> LEFT JOIN milestone m ON t.milestone = m.name
>
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Trac
Users" group.
To post to this group, send email to trac-users@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/trac-users?hl=en
-~----------~----~----~----~------~----~------~--~---
