I am new to CRDB. Can someone help me in converting varchar to Date in CRDB.
Can we use the CAST function
I am new to CRDB. Can someone help me in converting varchar to Date in CRDB.
Can we use the CAST function
I hope you’re enjoying CockroachDB! Yes, you can use casting for this. For example,
root@:26257/defaultdb> select '2020-12-09'::date;
date
--------------------------------
2020-12-09 00:00:00+00:00:00
However, if the varchar is in a different format, I don’t think you can convert that within CockroachDB, since this issue remains open: https://github.com/cockroachdb/cockroach/issues/3781