combine log parser date and time columns of IISlog into datetime

I have a Sql table with a datetime datatype and how can i combine the date
and time columns of the IIS log files into this single column using log
parser

I tried "select date+time into sqltable from " and it didnt like the
date+time. How can I go about it ?

Thanks

Re: combine log parser date and time columns of IISlog into datetime

I got the answer.. to_timestamp(date,time)


"Hassan" wrote in message
news:Oa6%23znTRIHA.4752@TK2MSFTNGP05.phx.gbl...
>I have a Sql table with a datetime datatype and how can i combine the date
>and time columns of the IIS log files into this single column using log
>parser
>
> I tried "select date+time into sqltable from " and it didnt like
> the date+time. How can I go about it ?
>
> Thanks