Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive, mail # user - Converting Timestamp to Date omly


Copy link to this message
-
Converting Timestamp to Date omly
Raihan Jamal 2012-07-18, 20:11
This is the Timestamp *1338674299000*

When I tried converting the above timestamp into the date only.

I got this below result for date by using this syntax-
*to_date(from_unixtime(cast(prod_and_ts.timestamps
as BIGINT)))*

*44390-11-25*

*
*

*
*

Anything wrong I am doing in my syntax?
*Raihan Jamal*