[ https://issues.apache.org/jira/browse/PIG-1310?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12849528#action_12849528 ]
Russell Jurney commented on PIG-1310: ------------------------------------- Thanks, Alan, I'll add all those changes tonight. I confess to not really testing CustomFormatToISO other than the test case, I'll update the docs :) As to ISO format - I will link to it and jodatime, and I would suggest ISO8601 be the standard representation of datetimes in Pig, as it handles time zones and is sortable as text - which is nice. > ISO Date UDFs: Conversion, Rounding and Date Math > ------------------------------------------------- > > Key: PIG-1310 > URL: https://issues.apache.org/jira/browse/PIG-1310 > Project: Pig > Issue Type: New Feature > Components: impl > Reporter: Russell Jurney > Fix For: 0.7.0 > > Attachments: datetime.patch, datetime2.patch > > Original Estimate: 168h > Remaining Estimate: 168h > > I've written UDFs to handle loading unix times, datemonth values and ISO 8601 > formatted date strings, and working with them as ISO datetimes using jodatime. > The working code is here: > http://github.com/rjurney/oink/tree/master/src/java/oink/udf/isodate/ > It needs to be documented and tests added, and a couple UDFs are missing, but > these work if you REGISTER the jodatime jar in your script. Hopefully I can > get this stuff in piggybank before someone else writes it this time :) The > rounding also may not be performant, but the code works. > Ultimately I'd also like to enable support for ISO 8601 durations. Someone > slap me if this isn't done soon, it is not much work and this should help > everyone working with time series. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.