I am looking for a mysql function to convert a column of 5 digit dates to “YYYY-mm-dd” format. eg 45050. I also have the date in ‘04.05.2023 0:00:00’ . Converting either will do.
I tried select DATE(“YYYY-mm-dd”,45050); and got a null value
I am looking for a mysql function to convert a column of 5 digit dates to “YYYY-mm-dd” format. eg 45050. I also have the date in ‘04.05.2023 0:00:00’ . Converting either will do.
I tried select DATE(“YYYY-mm-dd”,45050); and got a null value