Hello trac-users! Apologies if this has been discussed before but I can't seem to find it..
I need to integrate trac with an external system, and feed updates from the external system into trac. To do this I need to insert new tickets or amendments, and hence I need to get the date format correct. In the current system I have dates that look like: SELECT id, changetime from ticket limit 10 .. id changetime 265 1286961684095707 8 1284391607878091 9 1283794516523005 14 1283168712679360 19 1284370478825691 22 1283168712679360 32 1283168712679360 33 1283168712679360 34 1283168712679360 36 1284486365699645 Could someone please help me to parse the changetime field? I've tried postgresql datetime() and also variations of SELECT EXTRACT(EPOCH FROM TIMESTAMP WITH TIME ZONE '2001-02-16 20:38:40-08'); but I don't get any valid data out. Any help would be appreciated. My system: - Centos 5.4 - Trac 0.12.2 - Postgresql 8.1.22 - python 2.4.3 - integration glue with perl 5.8.8.32... preferred -- 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.
