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