[Feature] support unix_timestamp() with microseconds

[zclllyybb]

Search before asking

• I had searched in the issues and found no similar issues.

Description

mysql:

select unix_timestamp(cast('2020-12-12 12:12:12.123' as datetime(3)));


unix_timestamp(cast('2020-12-12 12:12:12.123' as datetime(3)))
--
1607746332.123

ours:

mysql> select unix_timestamp(cast('2020-12-12 12:12:12.123' as datetimev2(3)));
+------------+
| 1607746332 |
+------------+
| 1607746332 |
+------------+
1 row in set (0.10 sec)

so we need a new version of unix_timestamp which could calculate the microseconds.

Use case

No response

Related issues

No response

Are you willing to submit PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct

[YangWithU]

Hello, I'd like to take the issue

[zclllyybb]

Hello, I'd like to take the issue

sure, please add my wechat torch-wood_

[zhbdesign]

支持13位毫秒是不是更好

[zclllyybb]

支持13位毫秒是不是更好

we should be compatible with mysql first. the timestamp with 13-digit is also considerable then.

[435qb]

Can I work on this？