I tried the above problem with a string and solved it as below:
val df = sc.parallelize(Seq("08-26-2016")).toDF("Id")
df.createOrReplaceTempView("table1")
val bdf = spark.sql("""select from_unixtime(unix_timestamp(Id, 'MM-dd-yyyy')) as new_format ...
