Query from a timestamp based on a date?

Question

How do I execute a query based on date? As you can see below, I have a table with the attribute PURCHASEDATE as a timestamp. enter image description here My current query is

 String query = "SELECT t FROM TransactionE t WHERE t.purchaseDate = '" + currentDate + "'";

currentDate in this case is "2013-10-22"

My query above would never return a result because of the timestamp. How do I query from a timestamp based on a date?

Thanks guys! =)

Can you use a `PreparedStatement` ? Would be easier to set the `Date` directly than using a `String` to represent the `Date` — Jonathan Drapeau, Oct 22 '13 at 17:23

score 0 · Answer 1 · edited May 23 '17 at 10:31

0

How to return the date part only from a SQL Server datetime datatype

Use the answer given here.

edited May 23 '17 at 10:31

Community

1
1

answered Oct 22 '13 at 17:20

Daniel E.

2,029
3
22
28

If that's the case, the question is a duplicate. – Jonathan Drapeau Oct 22 '13 at 17:23

Query from a timestamp based on a date?

1 Answers1