Popular Posts

  • Backup Plans for Data Loss
    SQLServerCentral » Latest topics Backup Plans for Data Loss Comments posted to this topic are about the item [B] Backup Plans for D...
  • Asymmetric Processor Cores
    SQLblog.com - The SQL Server blog spot on the web Asymmetric Processor Cores Most Intel processors use one of two cores, the main-l...
  • A New New World
    SQLServerCentral » Latest topics A New New World Comments posted to this topic are about the item [B] A New New World [/B] more in...

SQLblog.com - The SQL Server blog spot on the web

Loading...

Saturday, November 11, 2017

Date Search

SQLServerCentral » Latest topics
Date Search
Hi,

I have in a data row:  column [date]   2017-11-06 01:17:34.000

I only want to search for values if the year is 2015.  How do I do this?

where [date] like '%2015"          ?
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)