How can i save DATETIME to the database?

**ashin** · 08-22-2010, 05:15 PM

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

**Fubarable** · 08-22-2010, 08:20 PM

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** · 08-23-2010, 03:16 AM

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

**ashin** · 08-23-2010, 10:02 PM

this is my code part..

Java Code:

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

Java Code:

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** · 08-24-2010, 02:33 AM

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..