.Net Basic

This blogs gives introduction to C#.NET programming for beginners. This blogs assumes that you have no programming experience whatsoever. It's a lot easier than you think, and can be a very rewarding hobby!after Refer this blog

26 June 2009

Compare 2 different dates without seconds in sqlserver 2005

select
(convert(varchar(10),DateTime1,103) + ' ' + convert(varchar(5),DateTime1,108))
,convert(varchar(10),DateTime2,103)+ ' '+ convert(varchar(5),DateTime2,108) from MIB_Time_Scheduling
where convert(varchar(10),DateTime1,103) = convert(varchar(10),DateTime1,103) and convert(varchar(5),DateTime2,108)=convert(varchar(5),DateTime2,108)

Labels: , ,

posted by Mohan @ 12:50 AM

0 Comments:

Post a Comment

Subscribe to Post Comments [Atom]

<< Home