Formatting Time

[bunnyweb]

Hi. I am hoping someone out there can help me.

I am querying on a date/time field in MS Access and receiving a value back that looks something like:

1899-12-30 15:45:00

I would like the above to return:

3:45 PM

I have looked up the Java Time class, but that doesn't seem to be getting me anywhere.

Any suggestions on how I might do this?

Thanks!

Rachel

 

[palbano]

Remember that java.sql.Date extends java.util.Date

class TimeDisplayTest{
	
	static void test( java.util.Date dt){
		java.text.SimpleDateFormat sdf = new java.text.SimpleDateFormat("hh:mm a");
		String str = sdf.format(dt);
		System.out.println( str);
	}
}

-pete