Problem when insert Date to database(SQL)

[hungleon88]

When i insert a record with Date to database , it include Month/Day/year and something stupid like 00:00:00
how can we remove 00:00:00 ??
or how can we only insert month/day/year??

[masijade]

Change the way you're displaying it?

Use getDate rather than getString?

[hungleon88]

the problem here is i use method getvalueAt of DefaultModelTable , and this method return an Object , so i cannot casting to Date type (
and when i display it, it include 00:00:00

[masijade]

the problem here is i use method getvalueAt of DefaultModelTable , and this method return an Object ,

And? What do you think a Date is? Cottage Cheese? A Date is also an Object, did you even try to cast it?

so i cannot casting to Date type (

And, did you even try?

and when i display it, it include 00:00:00

Then what you are printing is either a Date (with no time data) or a String. With a Date, no problem, just cast it, with a String, no problem, use SimpleDateFormat, and parse it. If what you had were actually an instance of "Object" (as you claim) then it would print something like "java.lang.Object@d9f9c3", and not any kind of date/time text.


Show the code you're using (only the relevant parts please, not some novel). And, please, don't tell me you have all sorts of persistence and business logic code tied up in the middle of your GUI code.

[neeraj.singh]

we have defferent date format methods
you can use that...
for date at backend side
use
to_date(date_var, 'yyyy/mm/dd')

[satkk]

I got this code working, try this, dont know whether its the right approach
String datestring= some string(getText() or getParameter())
java.util.Date dt=new java.util.Date();
java.sql.Date dte=new java.sql.Date(dt.getTime());
java.sql.Date dte1=dte.valueOf(datestring);
insert this dte1 to database

[OrangeDog]

That code just adds a random timestamp to the date, which is probably not what you want to do. If your data includes times then include them, of not, leave the time as 00:00:00.

All Date objects include a timestamp. If you don't want to see it, then only print the date part.