Java insert into sql with current date

Question

I have a table called order with userID, itemID , dateOfOrder

How do I insert a row with today's date?

I've tried for example:

INSERT INTO lending 
VALUES(111, 1, SELECT CURDATE())

but it doesn't work. any idea what is the correct syntax?

SELECT CURDATE() works fine and it returns the correct date. my problem is with the syntax within the insert. — ronn jack
– ronn jack, Commented Jan 13, 2013 at 20:16
Ah, I see now. The SELECT is superfluous in this case. SQL statements aren't structured that way, you just call the function to get the value you need. — David
– David, Commented Jan 13, 2013 at 20:18

marc_s · Accepted Answer · 2013-01-13 21:08:31Z

1

Problem solved:

INSERT INTO lending VALUES(111, 1, CURDATE())

instead of

INSERT INTO lending VALUES(111, 1, **SELECT** CURDATE())

edited Jan 13, 2013 at 21:08

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

answered Jan 13, 2013 at 20:17

ronn jack

1811 gold badge3 silver badges12 bronze badges

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

Comments

Windle · Accepted Answer · 2013-01-13 20:19:30Z

0

You didn't specify which RDBMS you are using, so here are two of the main ones: If you are using MySql look at the NOW() method. If you are using Oracle check out SYSDATE. For anything else, e.g. MS SQL, some quick googling should find you an answer.

answered Jan 13, 2013 at 20:19

Windle

1,3902 gold badges16 silver badges34 bronze badges

5 Comments

user330315 Over a year ago

Or simply use the standard CURRENT_DATE function. That works in nearly all DBMS.

Windle Over a year ago

I've always used NOW, SYSDATE, etc. because I always seem to need the time as well.

user330315 Over a year ago

The (ANSI) standard function would be CURRENT_TIMESTAMP

Windle Over a year ago

@a_horse_with_no_name Good to know. And looking at the docs, NOW and CURRENT_TIMESTAMP are actually the same thing in MySQL - checks out in sqlfiddle. SYSDATE and CURRENT_TIMESTAMP turn out different in Oracle, but the timestamp can take a format mask according to the docs so it can probably work out in the end. Learned some new stuff, thanks =)

ronn jack Over a year ago

NOW() isn't good for me as it returns the date and hour... i need just the date. anyhow the problem has been solved.. see my reply above :)

Collectives™ on Stack Overflow

Java insert into sql with current date

2 Answers 2

Comments

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related