/**
 * END USER LICENSE AGREEMENT (“EULA”)
 *
 * READ THIS AGREEMENT CAREFULLY (date: 9/13/2011):
 * http://www.akiban.com/licensing/20110913
 *
 * BY INSTALLING OR USING ALL OR ANY PORTION OF THE SOFTWARE, YOU ARE ACCEPTING
 * ALL OF THE TERMS AND CONDITIONS OF THIS AGREEMENT. YOU AGREE THAT THIS
 * AGREEMENT IS ENFORCEABLE LIKE ANY WRITTEN AGREEMENT SIGNED BY YOU.
 *
 * IF YOU HAVE PAID A LICENSE FEE FOR USE OF THE SOFTWARE AND DO NOT AGREE TO
 * THESE TERMS, YOU MAY RETURN THE SOFTWARE FOR A FULL REFUND PROVIDED YOU (A)
 * DO NOT USE THE SOFTWARE AND (B) RETURN THE SOFTWARE WITHIN THIRTY (30) DAYS
 * OF YOUR INITIAL PURCHASE.
 *
 * IF YOU WISH TO USE THE SOFTWARE AS AN EMPLOYEE, CONTRACTOR, OR AGENT OF A
 * CORPORATION, PARTNERSHIP OR SIMILAR ENTITY, THEN YOU MUST BE AUTHORIZED TO
 * SIGN FOR AND BIND THE ENTITY IN ORDER TO ACCEPT THE TERMS OF THIS AGREEMENT.
 * THE LICENSES GRANTED UNDER THIS AGREEMENT ARE EXPRESSLY CONDITIONED UPON
 * ACCEPTANCE BY SUCH AUTHORIZED PERSONNEL.
 *
 * IF YOU HAVE ENTERED INTO A SEPARATE WRITTEN LICENSE AGREEMENT WITH AKIBAN FOR
 * USE OF THE SOFTWARE, THE TERMS AND CONDITIONS OF SUCH OTHER AGREEMENT SHALL
 * PREVAIL OVER ANY CONFLICTING TERMS OR CONDITIONS IN THIS AGREEMENT.
 */
package com.akiban.server.types3.mcompat.mfuncs;

import com.akiban.server.types3.*;
import com.akiban.server.types3.common.DateExtractor;
import com.akiban.server.types3.mcompat.mtypes.MDatetimes;
import com.akiban.server.types3.mcompat.mtypes.MNumeric;
import com.akiban.server.types3.pvalue.PValueSource;
import com.akiban.server.types3.pvalue.PValueTarget;
import com.akiban.server.types3.texpressions.TInputSetBuilder;
import com.akiban.server.types3.texpressions.TOverloadBase;
import org.joda.time.MutableDateTime;

public abstract class MUnixTimestamp extends TOverloadBase {

    private static final int DATE_INDEX = 0; 
    
    public static final TOverload INSTANCE = new MUnixTimestamp() {
         @Override
            protected void buildInputSets(TInputSetBuilder builder) {
                builder.covers(MDatetimes.DATETIME, 0);
            }

            @Override
            protected void doEvaluate(TExecutionContext context, LazyList<? extends PValueSource> inputs, PValueTarget output) {
                long input = inputs.get(0).getInt64();

                long[] datetime = DateExtractor.getDatetime(input);
                MutableDateTime date = (MutableDateTime) context.exectimeObjectAt(DATE_INDEX);
                if (date == null) {
                    context.putExectimeObject(DATE_INDEX, date = new MutableDateTime());
                }
                date.setDateTime((int)datetime[0], (int)datetime[1], (int)datetime[2], 
                            (int)datetime[3], (int)datetime[4], (int)datetime[5], 0);
                int millis = (int) date.getMillis();
                output.putInt32(millis <= 0 ? 0 : millis);
            }
    };

    @Override
    public String overloadName() {
        return "TIMESTAMP";
    }

    @Override
    public TOverloadResult resultType() {
        return TOverloadResult.fixed(MNumeric.INT.instance());
    }
}

@@ -1813,55 +1813,8 @@
 se %7B
-%0A%0A    private static final int DATE_INDEX = 0; 
 %0A   
@@ -2302,19 +2302,15 @@
 tor.
-getDatetime
+extract
 (inp
@@ -2357,378 +2357,64 @@
 e = 
-(MutableDateTime) context.exectimeObjectAt(DATE_INDEX);%0A                if (date == null) %7B%0A                    context.putExectimeObject(DATE_INDEX, date = new MutableDateTime());%0A                %7D%0A                date.setDateTime((int)datetime%5B0%5D, (int)datetime%5B1%5D, (int)datetime%5B2%5D, %0A                            (int)datetime%5B3%5D, (int)datetime%5B4%5D, (int)datetime%5B5%5D, 0
+DateExtractor.getMutableDateTime(context, datetime, true
 );%0A 

modify doEvaluate with updated DateExtractor methods