Application: gvSIG desktop

package org.gvsig.expressionevaluator.impl.function.date;

import java.text.ParseException;

import java.text.SimpleDateFormat;

import java.util.Date;

import org.apache.commons.lang3.Range;

import static org.gvsig.expressionevaluator.ExpressionBuilder.FUNCTION_TIMESTAMP;

import org.gvsig.expressionevaluator.Interpreter;

import org.gvsig.expressionevaluator.spi.AbstractFunction;

public class TimestampFunction extends AbstractFunction {

    public TimestampFunction() {

        super("Date", FUNCTION_TIMESTAMP,Range.is(1),

            "Returns a time stamp from the arguments",

            FUNCTION_TIMESTAMP+"({{timestamp}})",

            new String[]{

                "timestamp - a string with a date/time"

            },

            "Timestamp"

        );

    }

    @Override

    public boolean allowConstantFolding() {

        return true;

    }

    @Override

    public Object call(Interpreter interpreter, Object[] args) {

        Object date_obj = getObject(args, 0);

        if( date_obj instanceof Date ) {

            return new java.sql.Timestamp(((Date) date_obj).getTime());

        }

        String date = getStr(args, 0);

        SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");

        try {

            java.sql.Timestamp x = java.sql.Timestamp.valueOf(date);

            return x;

        } catch (Exception ex) {

            throw new RuntimeException("Can't parse timestamp value '"+date+"' expected format 'yyyy-MM-dd HH:mm:ss'.", ex);

        }

    }

}