Require to convert varchar to Date

General
#1

I am new to CRDB. Can someone help me in converting varchar to Date in CRDB.

Can we use the CAST function

#2

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