First page Back Continue Last page Image

Using Concatenate to reassemble strings

Because both the Date and Time needed additional characters to be in the proper format, I used CONCAT_WS (With Separator) instead of CONCAT

Now Everything is string, But I want to cast numbers and dates to proper data type

Date Separator “-”

Time Separator “:”