Datediffernce in sql

  declare @Temp varchar(100)

  set @Temp='year'

  select

   case @Temp

   when 'year' then (select DATEDIFF(year,'2013-01-01','2015-01-01'))

  

   when 'month' then (select DATEDIFF(MONTH,'2013-01-01','2015-01-01'))

      when 'day' then (select DATEDIFF(DAY,'2013-01-01','2015-01-01'))

         when 'week' then (select DATEDIFF(WEEK,'2013-01-01','2015-01-01'))

         when 'hour' then (select DATEDIFF(HOUR,'2013-01-01','2015-01-01'))

          when 'minute' then (select DATEDIFF(MINUTE,'2013-01-01','2015-01-01'))

           when 'second' then (select DATEDIFF(SECOND,'2013-01-01','2015-01-01'))

         

   end

• Tweet
• Share
• Share
• Share
• Share

Sign up here with your email