Hi Weiqing,
Here is a code fragment from the UDF code that converts a string to the
Java "Date" type, taken from
https://github.com/apache/incubator-trafodion/blob/master/core/sql/src/main/java/org/trafodion/sql/udr/TupleInfo.java
Date resultDate;
String val = getString(colNum);
if (wasNull_)
return new Date(0);
DateFormat df;
try {
switch (t.getSQLType())
{
case DATE:
// yyyy-mm-dd
df = new SimpleDateFormat ("yyyy-MM-dd");
resultDate = df.parse(val);
break;
case TIME:
df = new SimpleDateFormat ("HH:mm:ss");
resultDate = df.parse(val);
break;
case TIMESTAMP:
df = new SimpleDateFormat ("yyyy-MM-dd HH:mm:ss");
resultDate = df.parse(val);
break;
default:
throw new UDRException(38900,
"getTime() not supported for SQL
type %d",
t.getSQLType().ordinal());
}
}
catch (java.text.ParseException e1) {
throw new UDRException(
38900,
"Unable to parse datetime string %s
for conversion to Date",
val);
}
Note that some of the enums, Exceptions and variables won't match your
case, but I hope the general idea is useful.
Hans
On Wed, Mar 23, 2016 at 11:27 PM, Weiqing Xu <[email protected]> wrote:
> Hi All,
>
> As default, sqlcli return DATE value in *String format* in JDBC T2 Driver.
> I want to get the DATE in Binary format since MT-DCS need use JDBC t2
> Driver.
>
> Does anyone know how to do it ?
>
> By the way, mxosrvr get the DATE value as Binary from SQLCLI , so I think
> it's possible as jdbc t2 too.
>
> Best Regards,
> Weiqing
>
