Compare date

• ranganathanmca

  SSC Eights!

  Points: 920

  More actions

  March 10, 2011 at 4:09 am

  #248028

  Hi guys.,

  I need to compare 2 different type of date first date format :

  2011 1

  2011 2

  2011 3

  second date format :

  July 2011

  June 2011

  April 2011

  March 2011

  February 2011

  compare the month if it's equal we need to display the data,Please share some example queries

  Thanks for advance

  Ranganathan Palanisamy

• Kiara

  SSCarpal Tunnel

  Points: 4185

  More actions

  March 10, 2011 at 5:26 am

  #1297006

  Are these char or (n)varchar fields? Or some other data type?

  -Ki

• Krishnraj

  SSCrazy

  Points: 2027

  More actions

  March 10, 2011 at 7:53 am

  #1297107

  There are some in-built sql function available in sql server like say;

  DatePart, DateDiff and DateName which may help you out.

  Plz refere the syntax from MSDN of above function.

  Hope, it may be helpfull to u