subject:"date format question"

Re: date format question

2012-09-17 Thread Ashish Thusoo

You could use the unix_timestamp function ... unix_timestamp(ts, ) >= unix_timestamp("2012-09-10", '-MM-dd') ... something on those lines Also checkout https://cwiki.apache.org/Hive/languagemanual-udf.html#LanguageManualUDF-DateFunctions for more datetime functions in Hive. Ashish On Mon,

date format question

2012-09-17 Thread zuohua zhang

I have a date column in this format: Mon Jul 16 14:05:12 PDT 2012 I want to select all records > 2012-09-01. How to do? Thanks!