I am trying to pull up the tickets listed as 'defect' that were reported in the last 24 hours for our project in trac. However, the time for the ticket is stored as a long integer (in seconds) which I cannot compare with the postgres date-time format. All the postgres functions like now(), current_time, localtimestamp, etc. return the value in date-time format which cannot be compared with the integer value of 'time' field for ticket. Can someone please help, its really urgent.
--~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Trac Users" group. To post to this group, send email to [email protected] 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 -~----------~----~----~----~------~----~------~--~---
