>>I see, never mind then. I wanted to help someone by easier way. I'll play at night myself.
>
>Look up convert: select convert(char(8), schrun, 108) as mytime from msgschdl
>
>works for me (the datetime column is schrun and the table is msgschdl)
Very nice, thanks, Tracy.
declare @test table (myValue varchar(max), dt datetime)
INSERT INTO @Test (MyValue, dt)
VALUES ('adddd', GETDATE()),
('bgfgfg', getdate()-10),
('bgfgfg', getdate()-15)
SELECT convert(char(8), dt, 108) as mytime
FROM @Test where myValue > 'a' and myValue < 'mzzzzzzzzzzzzzzzzzzzzzzzzz'
If it's not broken, fix it until it is.
My Blog