Santhosh K S

Santhosh K S

  • NA
  • 34
  • 37.5k

reply fast as possible?

May 18 2012 3:23 AM
select convert(smalldatetime,'14/05/2012 20:20:00',103)
output is 2012-05-14 20:20:00
But 
i need  date in terms of 15/04/2012 20:20:00,Because i need to compare  15/04/2012 20:20:00  with column of type smalldatetime column in a table please suggest........
thanks in advance

Answers (5)