Validate_TimestampHelp=Not a valid timestamp. Should be in the format YYYY-MM-DD hh:mm:ss.fffffffff, where ffffffffff indicates nanoseconds.

DateFormat_Timestamp_WithoutNanos=yyyy-MM-dd HH:mm:ss.

			converterMap.put(new Pair("java.sql.Timestamp", "java.lang.String"), "org.eclipse.core.internal.databinding.conversion.TimestampToStringConverter"); //$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$

			converterMap.put(new Pair("java.lang.String", "java.sql.Timestamp"), "org.eclipse.core.internal.databinding.conversion.StringToTimestampConverter"); //$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$

import java.sql.Timestamp;

import org.eclipse.core.internal.databinding.conversion.StringToTimestampConverter;

import org.eclipse.core.internal.databinding.validation.StringToTimestampValidator;

					} else if (Timestamp.class.equals(toType)

							&& converter instanceof StringToTimestampConverter) {

						result = new StringToTimestampValidator(

								(StringToTimestampConverter) converter);

/*******************************************************************************

 * Copyright (c) 2007 Matt Carter and others.

 * All rights reserved. This program and the accompanying materials

 * are made available under the terms of the Eclipse Public License v1.0

 * which accompanies this distribution, and is available at

 * http://www.eclipse.org/legal/epl-v10.html

 *

 * Contributors:

 *     Matt Carter - Initial API and implementation

 ******************************************************************************/

package org.eclipse.core.internal.databinding.validation;

import org.eclipse.core.databinding.validation.IValidator;

import org.eclipse.core.databinding.validation.ValidationStatus;

import org.eclipse.core.internal.databinding.BindingMessages;

import org.eclipse.core.internal.databinding.conversion.StringToTimestampConverter;

import org.eclipse.core.runtime.IStatus;

import org.eclipse.core.runtime.Status;

/**

 * @since 1.0

 */

public class StringToTimestampValidator implements IValidator {

	private final StringToTimestampConverter converter;

	/**

	 * @param converter

	 */

	public StringToTimestampValidator(StringToTimestampConverter converter) {

		this.converter = converter;

	}

	/*

	 * (non-Javadoc)

	 * 

	 * @see org.eclipse.core.databinding.validation.IValidator#validate(java.lang.Object)

	 */

	public IStatus validate(Object value) {

		Object convertedValue = converter.convert(value);

		//The StringToTimestampConverter returns null if it can't parse the timestamp.

		if (convertedValue == null) {

			return ValidationStatus.error(getErrorMessage());

		}

		return Status.OK_STATUS;

	}

	/*

	 * Returns the error message for an invalid date.

	 */

	protected String getErrorMessage() {

		return BindingMessages.getString("Validate_TimestampHelp"); //$NON-NLS-1$

	}

}

/*******************************************************************************

 * Copyright (c) 2007 Matt Carter and others.

 * All rights reserved. This program and the accompanying materials

 * are made available under the terms of the Eclipse Public License v1.0

 * which accompanies this distribution, and is available at

 * http://www.eclipse.org/legal/epl-v10.html

 *

 * Contributors:

 *     Matt Carter - Initial API and implementation

 ******************************************************************************/

package org.eclipse.core.internal.databinding.conversion;

import java.sql.Timestamp;

import java.text.ParseException;

import java.util.Date;

import org.eclipse.core.databinding.conversion.IConverter;

import org.eclipse.core.internal.databinding.BindingMessages;

import com.ibm.icu.text.DateFormat;

import com.ibm.icu.text.SimpleDateFormat;

/**

 * Convert a String to a java.sql.Timestamp.

 * 

 * Accepts JDBC timestamp escape format: yyyy-mm-dd hh:mm:ss.fffffffff, where ffffffffff indicates nanoseconds,

 * and the same format adapted for the current locale. 

 * 

 * Empty strings are converted to a null Timestamp.

 * 

 * @since 1.0

 */

public class StringToTimestampConverter implements IConverter {

	private DateFormat df = new SimpleDateFormat(

			BindingMessages.getString("DateFormat_Timestamp_WithoutNanos")); //$NON-NLS-1$

	public Object convert(Object fromObject) {

		if(fromObject == null) return ""; //$NON-NLS-1$

		String s = (String) fromObject;

		int p = s.lastIndexOf('.');

		if(p == -1) return tryNative(fromObject);

		int nanos;

		try { 

			nanos = Integer.parseInt(s.substring(p+1));

		} catch(NumberFormatException e) {

			return tryNative(fromObject);

		}

		Date date;

		try {

			date = df.parse(s.substring(0, p));

		} catch(ParseException e) {

			return tryNative(fromObject);

		}

		if(date == null) return tryNative(fromObject);

		Timestamp t = new Timestamp(date.getTime());

		t.setNanos(nanos);

		return t;

	}

	private Object tryNative(Object fromObject) {

		try {

			return Timestamp.valueOf((String) fromObject);

		} catch(IllegalArgumentException e) {

			return null;

		} catch(Exception e) {

			return null;

		}

	}

	public Object getFromType() {

		return String.class;

	}

	public Object getToType() {

		return Timestamp.class;

	}

}

/*******************************************************************************

 * Copyright (c) 2007 Matt Carter and others.

 * All rights reserved. This program and the accompanying materials

 * are made available under the terms of the Eclipse Public License v1.0

 * which accompanies this distribution, and is available at

 * http://www.eclipse.org/legal/epl-v10.html

 *

 * Contributors:

 *     Matt Carter - Initial API and implementation

 ******************************************************************************/

package org.eclipse.core.internal.databinding.conversion;

import java.sql.Timestamp;

import org.eclipse.core.databinding.conversion.IConverter;

import org.eclipse.core.internal.databinding.BindingMessages;

import com.ibm.icu.text.DateFormat;

import com.ibm.icu.text.SimpleDateFormat;

/**

 * Convert a java.sql.Timestamp to a String using the current locale. 

 * 

 * Converts to a String in JDBC timestamp escape format: yyyy-mm-dd hh:mm:ss.fffffffff, 

 * where ffffffffff indicates nanoseconds, with delimiters adapted for the current locale. 

 * 

 * Null timestamp values are converted to an empty string.

 * 

 * @since 1.0

 */

public class TimestampToStringConverter implements IConverter {

	private DateFormat df = new SimpleDateFormat(

			BindingMessages.getString("DateFormat_Timestamp_WithoutNanos")); //$NON-NLS-1$

	public Object convert(Object fromObject) {

		if(fromObject == null) return ""; //$NON-NLS-1$

		Timestamp t = (Timestamp) fromObject;

		return df.format(t)+toLZ(t.getNanos(), 9);

	}

	public Object getFromType() {

		return java.sql.Timestamp.class;

	}

	public Object getToType() {

		return String.class;

	}

	private static String toLZ(int i, int len)

	{

		// Converts integer to left-zero padded string, len chars long.

		String s = Integer.toString(i);

		if (s.length() > len) return s.substring(0,len);

		else if ( s.length() < len ) // pad on left with zeros

			return "000000000000000000000000000".substring(0, len - s.length ()) + s; //$NON-NLS-1$

		else return s;

	}

}