0) convert dates to ISO format via CustomFormatToISO 1) convert dates to unix time longs via ISOToUnix 2) use foreach/generate with ternary operator to add/subtract hours based on the value of the other field 3) convert dates back to ISO format with UnixToISO
Call it a day. Russell Jurney twitter.com/rjurney On Oct 3, 2012, at 10:54 AM, jamal sasha <[email protected]> wrote: > Hi, > > I have a table in format: > > Id: int, amount: float, true_date: chararray, time:chararray, > state:chararray > > > > Fortunately, there are only two states in my db. > > So if I have a state as “CA” then add +1 to datetime > > If state is “MA”, then add +5 to datetime > > And then save the results. > > Also a corner case.. > > While adding.. If due to addition the date changes.. then I have to add +1 > to true_date as well.. > > Any ideas
