format datetime string into date string

Question

Hi,

In dataflow of ADF, inside the derived column, how can I convert a datetime string into a date string?

for example:

2023-12-27 00:00:00.0000000

to

2023-12-27

and in-case there is no value then it does not fail during conversion.

thank you

Answer 1

convert a datetime string into a date string?

The data types datetime is a datetime, date is a date and a string is a string; there is no mix between.

A datetime do have a millisecond portion, you have to convert it date or you have to limit the string output to 10 characters to truncate the time portion.