You can use REGEX_EXTRACT with appropriate pattern and dummy ternary
write dummy jython UDF using java/jython classes for Datetime conversion
You can convert it to unix seconds using "native pig" and sort as integers:
dataWithSeconds = FOREACH dataWithddMMMyyyy GENERATE
ToDate('1970-01-01 00:00:00', 'yyyy-MM-dd HH:mm:ss'))
) as seconds;
ordered = ORDER dataWithSeconds by seconds;
2013/8/26 Ambastha, Abhishek <[EMAIL PROTECTED]>
> I have columns defined as string where dates are in the format ddMMMyyyy
> (e.g. 01JAN2009). I would like to sort this column in ascending order. For
> that, I need to convert string into date in the format 'ddMMMyyyy'.
> Please suggest how to do this.