0 - 2 of 2 tags for Quer

Hi all,
I have some problem about the query which finds the data between 2013-12-31 and today
I took invalid timestamp error.
The query I used looks like this:
select * from table1 where the_date between '2013-12-31' and current_time
 
Please help me!
 

Hi ,
 I have a partitioned table from 2013 and having almost 550 partitions.Most of the data looks redundant except the load date.So ,planning to identify the changes and remove the same attribute records and dump into a non-partitioned table.
What's the best approach to workout?
 
Example:
CREATE TABLE HODS
(