Dear great Minds,
Working with a SQL workbench, I have encountered Date coming in this format “2019-10-16T13:40:13”.
Please I am stuck on how I can separate this Date-Time field which comes in text format to:
- Date, then Time
- Split the single field into separate Date and Time fields, so that I am able to filter data fields according to Date.
I will appreciate immensely any help in this regards.
Thank you all.