I have a table, with types `varchar`, `datetime`, `datetime`:

```none
NAME | START | END
Bob  | 10/30 | 11/2

```

What's a SQL query can I look up to find out how to make that table be?:

```none
NAME | START | END
Bob  | 10/30 | 10/30
Bob  | 10/31 | 10/31
Bob  | 11/01 | 11/01
Bob  | 11/02 | 11/02

```

This is only ran once, and on a very small dataset. Optimization isn't necessary.