How can i save DATETIME to the database?

[ashin]

guys, how can i save the datetime format to database? i always got an error DUPLICATION in id..:confused:

[Fubarable]

I think that you're going to have to show some code as well as the error message itself (not your interpretation of the message).

[Eranga]

How did you save it, can you show it for US?

[ashin]

this is my code part..

final DateTime ftime = new DateTime(group,SWT.TIME|SWT.BORDER|SWT.SHORT);
		ftime.setBounds(130,150,73,23);
	final DateTime totime = new DateTime(group,SWT.TIME|SWT.BORDER|SWT.SHORT);
		totime.setBounds(130,180,73,23);

saving part... bold texts

Execute exc = new Execute();
				exc.ExecuteQuery("INSERT INTO tblfacultyscheduling(sy,courseid,insid,section,timefrom,timeto,day) VALUES('"+cmbSY.getText()+"','"+cmbCourse.getText()+"','"+cmbInsId.getText()
						+"','"+cmbSection.getText()+"','"+[B](ftime.getHours()+":"+ftime.getMinutes())[/B]+"','"+(totime.getHours()+":"+totime.getMinutes())+"','"+cmbDay.getText()+"')",factSched,cmbCourse.getText());
				exc=null;

[ashin]

hi guys, i already solved the half of my problem (no duplication of id anymore) but my problem is, how can i save the whole date to the database? the system can only save the hourse:minutes but the AM/PM is not.. thank you..

[Eranga]

If you define the correct data type in the database, and if you pass the relevant value it works. So where you stuck?