I want to insert the current date to my oracle database Bills. I am getting the date from system using
DateFormat dateFormat = new SimpleDateFormat("dd/MM/yyyy");
Date date = new Date();
is that possible to directly insert it into the database without converting to the default format (dd-month-yyyy) of DATE data type in Oracle?
Just in case you need CURRENT date, use:
INSERT INTO YOUR_TABLE (YOUR_DATE_COLUMN, COLUMN_2, COLUMN_3)
VALUES (SYSDATE, 1234, 567);
SYSDATE and CURRENT_DATE as the person who commented on the question suggested? Edit: Found the answer. SYSDATE is the date on the server while CURRENT_DATE is the date on the client. So SYSDATE is probably almost always the desired one, I'd think.You did not give any context on what interface you are using to communicate with the DB. Assuming plain JDBC, let the driver handle the problem, use a statement object and set the parameter(s) properly:
Connection connection = ...
PreparedStatement statement = connection.prepareStatement("INSERT INTO <TableNameHere> VALUES (?)");
statement.setObject(1, new java.sql.Date());
statement.executeUpdate();
(Error handling and fluff ommited) The JDBC driver will deal with the details on how to format the date as the database wants it. Don't even worry about it.
1) It is not mandatory to use the default dd/MM/yyyy format in while initializing SimpleDateFormatter. You have a list of options which can match to your requirement. SimpleDateFormat
CURRENT_DATEas a value literal in your SQL?insert into foo (some_date_column) values (current_date)SYSDATE, notCURRENT_DATE.SYSDATEis the date on the server whileCURRENT_DATEis the date on the client. I'd imagine you almost always want to insert the server's date into the database, not anything else.