• Ok, I will look at this, but entertain me

    insert [dbo].[AlarmDet]

    (JobStart)

    select

    --convert (Jobsatrt (),101)

    --SELECT convert(datetime, '23/07/2009', 103)

    --convert (datetime, Jobstart,103)

    --CONVERT(varchar, CONVERT(datetime, JobStart), 100)

    --cast(JobStart as date)

    from [SLADB].[dbo].[AlarmDetTest]

    How do I get this to work ? I know the format is M/d/yyyyHH:mm:ss

    Thanks

    Jay