https://community.databricks.com/t5/get-started-discussions/hi-i-am-trying-to-change-datatype-of-dob-column-from-stringtype/m-p/76189#M7612 <P>Hi I am trying to change datatype of DOB column from String type to DateType but getting issue<BR />"<SPAN>SparkUpgradeException: [] You may get a different result due to the upgrading to Spark &gt;= 3.0: Caused by: DateTimeParseException: Text '7/8/1972' could not be parsed at index 0"<BR /><BR />I have attached screenshots for your reference. Can someone help. I know this is a silly doubt but help is really appreciated ! Thanks in advance<BR /><BR /><BR /></SPAN></P><P><SPAN><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Screenshot 2024-06-30 at 6.50.42 PM.png" style="width: 999px;"><img src="https://community.databricks.com/t5/image/serverpage/image-id/9045i379BB65986353AAC/image-size/large/is-moderation-mode/true?v=v2&amp;px=999" role="button" title="Screenshot 2024-06-30 at 6.50.42 PM.png" alt="Screenshot 2024-06-30 at 6.50.42 PM.png" /></span><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Screenshot 2024-06-30 at 6.50.57 PM.png" style="width: 999px;"><img src="https://community.databricks.com/t5/image/serverpage/image-id/9044i0938A7ED47AAEA31/image-size/large/is-moderation-mode/true?v=v2&amp;px=999" role="button" title="Screenshot 2024-06-30 at 6.50.57 PM.png" alt="Screenshot 2024-06-30 at 6.50.57 PM.png" /></span><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Screenshot 2024-06-30 at 6.51.01 PM.png" style="width: 999px;"><img src="https://community.databricks.com/t5/image/serverpage/image-id/9048i0C514E6240E0C87F/image-size/large/is-moderation-mode/true?v=v2&amp;px=999" role="button" title="Screenshot 2024-06-30 at 6.51.01 PM.png" alt="Screenshot 2024-06-30 at 6.51.01 PM.png" /></span></SPAN></P> Sun, 30 Jun 2024 13:33:55 GMT parakh17 2024-06-30T13:33:55Z https://community.databricks.com/t5/get-started-discussions/hi-i-am-trying-to-change-datatype-of-dob-column-from-stringtype/m-p/76189#M7612 <P>Hi I am trying to change datatype of DOB column from String type to DateType but getting issue<BR />"<SPAN>SparkUpgradeException: [] You may get a different result due to the upgrading to Spark &gt;= 3.0: Caused by: DateTimeParseException: Text '7/8/1972' could not be parsed at index 0"<BR /><BR />I have attached screenshots for your reference. Can someone help. I know this is a silly doubt but help is really appreciated ! Thanks in advance<BR /><BR /><BR /></SPAN></P><P><SPAN><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Screenshot 2024-06-30 at 6.50.42 PM.png" style="width: 999px;"><img src="https://community.databricks.com/t5/image/serverpage/image-id/9045i379BB65986353AAC/image-size/large/is-moderation-mode/true?v=v2&amp;px=999" role="button" title="Screenshot 2024-06-30 at 6.50.42 PM.png" alt="Screenshot 2024-06-30 at 6.50.42 PM.png" /></span><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Screenshot 2024-06-30 at 6.50.57 PM.png" style="width: 999px;"><img src="https://community.databricks.com/t5/image/serverpage/image-id/9044i0938A7ED47AAEA31/image-size/large/is-moderation-mode/true?v=v2&amp;px=999" role="button" title="Screenshot 2024-06-30 at 6.50.57 PM.png" alt="Screenshot 2024-06-30 at 6.50.57 PM.png" /></span><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Screenshot 2024-06-30 at 6.51.01 PM.png" style="width: 999px;"><img src="https://community.databricks.com/t5/image/serverpage/image-id/9048i0C514E6240E0C87F/image-size/large/is-moderation-mode/true?v=v2&amp;px=999" role="button" title="Screenshot 2024-06-30 at 6.51.01 PM.png" alt="Screenshot 2024-06-30 at 6.51.01 PM.png" /></span></SPAN></P> Sun, 30 Jun 2024 13:33:55 GMT https://community.databricks.com/t5/get-started-discussions/hi-i-am-trying-to-change-datatype-of-dob-column-from-stringtype/m-p/76189#M7612 parakh17 2024-06-30T13:33:55Z https://community.databricks.com/t5/get-started-discussions/hi-i-am-trying-to-change-datatype-of-dob-column-from-stringtype/m-p/76230#M7613 <P>It's because the format you're using it wrong. Use `<SPAN>'M/d/yyyy'` instead.</SPAN></P> Mon, 01 Jul 2024 08:24:22 GMT https://community.databricks.com/t5/get-started-discussions/hi-i-am-trying-to-change-datatype-of-dob-column-from-stringtype/m-p/76230#M7613 Witold 2024-07-01T08:24:22Z