string to timestamp

[Klament J. Kruoghst]

Hi there,

1)I have a string of this type of format: dd MMM yyyy.
2)I want to end up with a Timestamp of this format: yyyy-mm-dd hh:mm:ss

I've gone back and forth between string, date, formatter, timestamp and I keep getting exceptions of all kinds, can anyone post a code that would begin with and end with the above formats in those type of objects?

Thanks in advance

[Paul Clapham]

1. Create a SimpleDateFormat object which matches that format.

2. Use it to parse a String to a Date.

3. Convert that Date to a long value using a method whose name I think might be getTime().

4. Pass that long value to a Timestamp constructor.

By the way it doesn't make sense to require that a Timestamp should have any kind of format. It's just a time stamp, it doesn't have a format. If you need to produce a String representation of the Timestamp using some particular format then:

1. Create a SimpleDateFormat object which matches that format.

2. Use it to format the Timestamp to a String.

[Rakesh K. Cherukuri]

Klament J. Kruoghst wrote:
2)I want to end up with a Timestamp of this format: yyyy-mm-dd hh:mm:ss

In the above line the month field 'mm' should be 'MM'. Coming to code part, hope this will help.

import java.util.Date;
import java.text.SimpleDateFormat;
import java.text.ParseException;
public class TestFormatter {
	public static void main(String[] args) {
		String strDate = "24 Jan 2011";
		SimpleDateFormat sdf = new SimpleDateFormat("dd MMM yyyy");
		SimpleDateFormat finalSdf = new SimpleDateFormat("yyyy-MM-dd hh:mm:ss");
		try{
			Date strConvToDate =  sdf.parse(strDate);
			System.out.println("Final date string : " + finalSdf.format(strConvToDate));
		}catch(ParseException e){
			System.err.println("Parse exception : " + e.getMessage());
		}
	}
}