https://community.cloudera.com/t5/Archives-of-Support-Questions/how-to-convert-a-date-from-different-format-to-one/m-p/170262#M50056 <P>this looks a timestamp not date, you can store this as string in hive table and retrive it using to_date() funtion,</P><P>or you can run some date transformation before inserting into hive table, it looks you are having RFC822 timestamp which you can convert into some hive known transformation like this, I am using a java program to </P><PRE>public class RFC822TimeStampConverter { public static void main(String[] args) { String rfcDate = "Tue, Dec 20 10:04:31 2016"; String pattern = "EEE, MMM DD HH:mm:ss YYYY"; SimpleDateFormat format = new SimpleDateFormat(pattern); try { Date javaDate = format.parse(rfcDate); System.out.println(javaDate.toString()); } catch (ParseException e) { e.printStackTrace(); } } }</PRE> Sat, 24 Dec 2016 16:18:04 GMT rajkumar_singh 2016-12-24T16:18:04Z https://community.cloudera.com/t5/Archives-of-Support-Questions/how-to-convert-a-date-from-different-format-to-one/m-p/170261#M50055 <P>i have a data in my HDFS,my date format in that file is Tue Dec 20 10:04:31 +0000 2016,when i create a hive table with field name created time and datatype date it store a null value. how to change that date formate in hive?</P> Sat, 24 Dec 2016 16:15:09 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/how-to-convert-a-date-from-different-format-to-one/m-p/170261#M50055 a_rajeshinfotec 2016-12-24T16:15:09Z https://community.cloudera.com/t5/Archives-of-Support-Questions/how-to-convert-a-date-from-different-format-to-one/m-p/170262#M50056 <P>this looks a timestamp not date, you can store this as string in hive table and retrive it using to_date() funtion,</P><P>or you can run some date transformation before inserting into hive table, it looks you are having RFC822 timestamp which you can convert into some hive known transformation like this, I am using a java program to </P><PRE>public class RFC822TimeStampConverter { public static void main(String[] args) { String rfcDate = "Tue, Dec 20 10:04:31 2016"; String pattern = "EEE, MMM DD HH:mm:ss YYYY"; SimpleDateFormat format = new SimpleDateFormat(pattern); try { Date javaDate = format.parse(rfcDate); System.out.println(javaDate.toString()); } catch (ParseException e) { e.printStackTrace(); } } }</PRE> Sat, 24 Dec 2016 16:18:04 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/how-to-convert-a-date-from-different-format-to-one/m-p/170262#M50056 rajkumar_singh 2016-12-24T16:18:04Z