Okay, what are the differences and similarities with use a date function for the same purpose? Is there a reason to go one route or the other?
On Mar 13, 2012, at 11:29 , Mark Grover wrote: > Hi Keith, > You should also consider writing you own UDF that takes in the date in > "American" format and spits out a lexicographical string. > That way you don't have to modify your base data, just use this newly created > from_american_date(String date) UDF to get your new date string in > > Mark Grover, Business Intelligence Analyst > OANDA Corporation > > www: oanda.com www: fxtrade.com > e: mgro...@oanda.com ________________________________________________________________________________ Keith Wiley kwi...@keithwiley.com keithwiley.com music.keithwiley.com "It's a fine line between meticulous and obsessive-compulsive and a slippery rope between obsessive-compulsive and debilitatingly slow." -- Keith Wiley ________________________________________________________________________________