.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: , ,

1 Comments:

At January 24, 2018 at 11:17 AM , Blogger Vale Co Xenia said...

Hi, Great.. Tutorial is just awesome..It is really helpful for a newbie like me.. I am a regular follower of your blog. Really very informative post you shared here. Kindly keep blogging. If anyone wants to become a .Net developer learn from Dot Net Training in Chennai. or learn thru Dot Net Training in Chennai. Nowadays Dot Net has tons of job opportunities on various vertical industry.
or Javascript Training in Chennai. Nowadays JavaScript has tons of job opportunities on various vertical industry.

 

Post a Comment

Subscribe to Post Comments [Atom]

<< Home