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!
Thanks for your replies,
Actually, I had not made a query with a timestamp before I met such a situation. Now I found a solution with parsing EXTRACT and CAST keywords.