bug(sink): json encoder does not preserve microsecond precision

[xiangjinwu]

No description provided.

[xuefengze]

It seems that the time type ignores the millisecond part in json encoder?

[xiangjinwu]

It seems that the time type ignores the millisecond part in json encoder?

Yes, and we need TimeHandlingMode to fix it without breaking backward compatibility.

[tabVersion]

It seems that the time type ignores the millisecond part in json encoder?

Yes, and we need TimeHandlingMode to fix it without breaking backward compatibility.

Can we resue the same options as the json parser in source?

[xiangjinwu]

It seems that the time type ignores the millisecond part in json encoder?

Yes, and we need TimeHandlingMode to fix it without breaking backward compatibility.

Can we resue the same options as the json parser in source?

Yes for the enum definition

risingwave/src/connector/src/parser/unified/json.rs

Lines 41 to 45 in 14ff124

	#[derive(Clone, Debug)]
	pub enum TimeHandling {
	Milli,
	Micro,
	}

Additionally it may need to be exposed as a format option #13109