/**
 * Converter for SQL dates.
 *
 * @author higa
 */
public class SqlDateConverter implements Converter {

    /**
     * The date pattern.
     */
    protected String pattern;

    /**
     * Constructs an instance.
     *
     * @param pattern
     *            the date pattern
     */
    public SqlDateConverter(final String pattern) {
        assertArgumentNotEmpty("pattern", pattern);

 * @author higa
 */
public class SqlDateConverterTest {

    /**
     * @throws Exception
     */
    @Test
    public void testGetAsObjectAndGetAsString() throws Exception {
        final SqlDateConverter converter = new SqlDateConverter("yyyy/MM/dd");
        final java.sql.Date result = (java.sql.Date) converter.getAsObject("2008/01/16");
        System.out.println(result);
        assertThat(converter.getAsString(result), is("2008/01/16"));

     * @return A {@link CopyOptions} with a SQL date converter applied.
     * @see CopyOptions#sqlDateConverter(String, CharSequence...)
     * @see SqlDateConverter
     */
    public static CopyOptions sqlDateConverter(final String pattern, final CharSequence... propertyNames) {
        return new CopyOptions().sqlDateConverter(pattern, propertyNames);
    }

    /**

     * @return This instance itself
     * @see SqlDateConverter
     */
    public CopyOptions sqlDateConverter(final String pattern, final CharSequence... propertyNames) {
        assertArgumentNotEmpty("pattern", pattern);

        return converter(new SqlDateConverter(pattern), propertyNames);
    }

    /**
     * Sets a converter for time.
     *

                is((Object) "19700101"));
    }

    /**
     * @throws Exception
     */
    @Test
    public void testSqlDateConverter() throws Exception {
        assertThat(new CopyOptions().sqlDateConverter("yyyyMMdd").convertValue(new java.sql.Date(0), "aaa", String.class),
                is((Object) "19700101"));
    }

    /**
     * @throws Exception
     */
    @Test