Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to Insert Current date into oracle database from a java program?

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?

like image 607
Aswin Avatar asked Jan 22 '26 03:01

Aswin


1 Answers

Just in case you need CURRENT date, use:

INSERT INTO YOUR_TABLE (YOUR_DATE_COLUMN, COLUMN_2, COLUMN_3) 
VALUES (SYSDATE, 1234, 567);
like image 144
yurin Avatar answered Jan 23 '26 20:01

yurin