I have a following insert statement as such:

```
INSERT INTO dt_tbl 
    SELECT id, name, date1
    from #tbl

```

For the `date1` it has just a date; example: `1/12/14`

I like to add a random value for seconds to it.