https://community.databricks.com/t5/data-engineering/using-a-udf-in-sql/m-p/34217#M24987 <P>Got it working (but going to post a new question momentarily): I needed to use timestamp(date '3000-01-01) instead of to_timestamp</P> Tue, 13 Sep 2022 15:43:02 GMT BradSheridan 2022-09-13T15:43:02Z https://community.databricks.com/t5/data-engineering/using-a-udf-in-sql/m-p/34216#M24986 <P>Afternoon everyone! I logged in hoping to see some suggestions but think maybe I need to reword the question a little <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P></P><P>How can I create a UDF that converts '30000101' to timestamp and then use it in a query like below?</P><P></P><P>%sql</P><P>select</P><P>field1,</P><P>field2,</P><P>nvl(somedatefield, myUDF)</P><P></P><P>In other words, if the somedatefield in the source is null, always return 30000101 formatted as Timestamp</P><P></P><P>thanks!!</P> Fri, 19 Aug 2022 13:38:38 GMT https://community.databricks.com/t5/data-engineering/using-a-udf-in-sql/m-p/34216#M24986 BradSheridan 2022-08-19T13:38:38Z https://community.databricks.com/t5/data-engineering/using-a-udf-in-sql/m-p/34217#M24987 <P>Got it working (but going to post a new question momentarily): I needed to use timestamp(date '3000-01-01) instead of to_timestamp</P> Tue, 13 Sep 2022 15:43:02 GMT https://community.databricks.com/t5/data-engineering/using-a-udf-in-sql/m-p/34217#M24987 BradSheridan 2022-09-13T15:43:02Z