Jdbc sql syntax error for date

Question

ResultSet resultObj = statementObj.executeQuery("SELECT EMPLOYEE_ID FROM JOB_HISTORY WHERE START_DATE > Convert(datetime, '2001-01-13' )");

I get this error while Iam executing the program:

java.sql.SQLSyntaxErrorException: ORA-00904: "DATETIME": invalid identifier

It always helps to read the manual: docs.oracle.com/cd/E11882_01/server.112/e41084/… — user330315
– user330315, Commented Mar 21, 2015 at 9:26

Gordon Linoff · Accepted Answer · 2015-03-20 19:30:41Z

2

If you are using Oracle, use Oracle syntax:

SELECT EMPLOYEE_ID
FROM JOB_HISTORY
WHERE START_DATE > DATE '2001-01-13';

The date keyword allows you to use ISO-standard syntax for date constants.

answered Mar 20, 2015 at 19:30

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Durandal Over a year ago

It would be more flexible to use a prepared statement and not worry about what format the DB actually wants. Leave the detail work to the JDBC driver, thats its job.

brso05 · Accepted Answer · 2015-03-20 19:30:30Z

0

Try this:

ResultSet resultObj = statementObj.executeQuery("SELECT EMPLOYEE_ID FROM JOB_HISTORY WHERE START_DATE > '2001-01-13'");

answered Mar 20, 2015 at 19:30

brso05

13.3k2 gold badges25 silver badges41 bronze badges

Comments

Brent Worden · Accepted Answer · 2015-03-21 05:08:51Z

0

try this

Query ="SELECT EMPLOYEE_ID FROM JOB_HISTORY WHERE START_DATE >'2001-01-13' ";
ResultSet resultObj = statementObj.executeQuery(Query);

edited Mar 21, 2015 at 5:08

Brent Worden

11k8 gold badges57 silver badges59 bronze badges

answered Mar 21, 2015 at 4:19

Ketan G

5171 gold badge5 silver badges22 bronze badges

Collectives™ on Stack Overflow

Jdbc sql syntax error for date

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related