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 wrote:
> And CREATED_TIME is string data type.
>
And CREATED_TIME is string data type.
*Raihan Jamal*
On Wed, Jul 18, 2012 at 2:48 PM, Raihan Jamal 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
