builtins: implement to_timestamp

[andyli]

Describe the problem

To use a timestamp value in decimal, in Postgres, I use the to_timestamp() function as follows

select to_timestamp(1646906263.278);

Since cockroach doesn't have to_timestamp(), I use a cast instead:

select 1646906263.278::timestamptz;

But it results in SQL Error [42846]: ERROR: invalid cast: decimal -> timestamptz

Casting an integer to timestamptz works, thought it loses precision:

select 1646906263::timestamptz; # removed .278

Environment:

• CockroachDB CCL v21.2.6 (x86_64-unknown-linux-gnu, built 2022/02/22 18:30:37, go1.16.6)

---

Instructions for contributors:

Add a built-in in https://github.com/cockroachdb/cockroach/blob/master/pkg/sql/sem/builtins/builtins.go
Add a test in https://github.com/cockroachdb/cockroach/blob/master/pkg/sql/logictest/testdata/logic_test/timestamp, and run make testbaselogic FILES='timestamp' TESTFLAGS='-rewrite' to test it.
Run make buildshort to regenerate automatically generated files.
Submit a PR.

---

Jira issue: CRDB-13671
Epic CRDB-14049

[blathers-crl]

Hello, I am Blathers. I am here to help you get the issue triaged.

Hoot - a bug! Though bugs are the bane of my existence, rest assured the wretched thing will get the best of care here.

I was unable to automatically find someone to ping.

If we have not gotten back to your issue within a few business days, you can try the following:

• Join our community slack channel and ask on #cockroachdb.
• Try find someone from here if you know they worked closely on the area and CC them.

_{🦉 Hoot! I am a Blathers, a bot for CockroachDB. My owner is otan.}

[otan]

thanks! i think our preference here is to implement to_timestamp, so changed accordingly.

[deepto98]

Hi, can I pick this up?

[rafiss]

@deepto98 sure, it's best if you go ahead and submit a PR as per the instructions in the issue, and following our contribution guidelines

[simplenotezy]

Just curious, when will this be released?

[rafiss]

@simplenotezy This will be a part of the v22.2 release. There are beta versions available for you to test with: https://www.cockroachlabs.com/docs/releases/v22.2.html