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 <IISLog>" and it didnt like the
date+time. How can I go about it ?

Thanks

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


"Hassan" <hassan [at] test.com> wrote in message
news:Oa6%23znTRIHA.4752 [at] 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 <IISLog>" and it didnt like
> the date+time. How can I go about it ?
>
> Thanks