string to_date(string timestamp) does the trick. The official hive UDF page has all the useful functions that are available: https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF
-Vijay On Wed, Jul 18, 2012 at 2:55 PM, Raihan Jamal <jamalrai...@gmail.com> wrote: > And CREATED_TIME is string data type. > > > > > Raihan Jamal > > > > On Wed, Jul 18, 2012 at 2:48 PM, Raihan Jamal <jamalrai...@gmail.com> wrote: >> >> This is the CREATED_TIME 2009-12-14 10:15:54 >> >> How I can get only the date part from the above created_time, just like >> below. >> >> 2009-12-14 >> >> Any suggestions will be appreciated. >> >> >> Raihan Jamal >> >
