Inserting date using SQL

[shuzo monsoon]

Hello, what I'm trying to do is insert data into a database table. 'normal' info is inserted fine but what I need to do is have the current date inserted with the information also. There is a date field in the table but is there a method that allows the current date to be inserted with the rest of the info?
Thanks!

[Ko Ko Naing]

See this as an example... I did it in oracle.... I hope it is applicable to other database as well, you change the function TO_DATE to corresponding function of database... Hope this helps...

String sql = "update tableName set";
sql += " recordDate = to_date('" + today.getDate().toString() + "','yyyy-mm-dd')";
sql += " where recordId = '" + record.getId() + "'";

[shuzo monsoon]

Thanks Ko, but I@m getting an error saying "today" is either a misplaced package name or a non existent entity. Any ideas?

[Ko Ko Naing]

today is a constant of the Date... U may set it in anywhere, b4 the code that I provided to you....
Maybe this might be helpful...

Date today = new Date();

[shuzo monsoon]

Thanks again Ko, but now there's an error saying -
"The type of this expression, "int", is not a valid reference type in this context." and it refers to the line -
today.getDate().toString()
Is it because I'm trying to assign the date to a string?

[Ko Ko Naing]

Originally posted by shuzo monsoon:
Thanks again Ko, but now there's an error saying -
"The type of this expression, "int", is not a valid reference type in this context." and it refers to the line -
today.getDate().toString()

Try this...

Instead of today.getDate().toString(), try to put new Date().toString() in the sql string I provided above

Is it because I'm trying to assign the date to a string?

No, it means that we are changing the date object to be a string... Hope it's solved...