Skip to content

Java Input Binding does not work with Date and Time types #422

Closed
@lucyzhang929

Description

@lucyzhang929

The java worker throws the following errors when using a Java input binding on a table with Date and Time column types.
Date:

Exception: ParseException: Unparseable date: "2022-10-25T00:00:00.000Z"
Stack: com.google.gson.JsonSyntaxException: Failed parsing '2022-10-25T00:00:00.000Z' as SQL Date; at path $[0].Date

Time:

Exception: ParseException: Unparseable date: "11:50:12"
[2022-10-25T18:50:37.437Z] Stack: com.google.gson.JsonSyntaxException: Failed parsing '11:50:12' as SQL Time; at path $[0].Time

Current workaround is to use String instead of java.sql.Date and java.sql.Time

This depends on the Java worker adding support for customizing the GSON serializer: Azure/azure-functions-java-worker#424.

Metadata

Metadata

Assignees

Type

No type

Projects

No projects

Relationships

None yet

Development

No branches or pull requests

Issue actions