What you want to see on DotNetFunda.com ?

Home Freshers Career Advice Articles Interviews Videos Forums Codes Blogs Jobs ASP.NET MVC Community Jokes Chat

Online : 9297 | Welcome, Guest! Register Login

Home > Code Snippets > SQL Server > Use DATEPART Function as a LIKE operator. ...

Winners

Winners & Prizes

Announcements

Like us on Facebook

Top Codes Authors

Thu, 23-May-2013 Authors

All Time Authors

7960

6200

5800

Latest members | More ...

(Statistics delayed by 5 minutes)

Use DATEPART Function as a LIKE operator.

Submit Code |

Search Codes |

Code Home |


SELECT * Your_Table_Name 

where (DATEPART(yy, Your_Column_Name) = 2012

AND DATEPART(mm, Your_Column_Name) ) = 10

AND DATEPART(dd, Your_Column_Name) ) = 18) 

order by Your_Column_Name desc

Found interesting? Add this to:

| More | Bookmark It

>> Write Response - Respond to this post and get points

More codes snippets
	Usage of Named Parameters Optional parameters Usage Of Ref and Out Parameters How we provide the source dynamically for Iframe tag ? Contexto Entity Framework How to set the meta tags dynamically in ASP.NET ? How to set the page title dynamically in ASP.NET ? How to use if else condition in aspx design page ? How to find out the particular string used by tables Submit Code \| More ...

General Notice: If you find plagiarised (copied) contents on this page, please let us know the original source along with your correct email id (to communicate) for further action.

Copyright © DotNetFunda.Com. All Rights Reserved. Copying or mimicking the site design and layout is prohibited. Logos, company names used here if any are only for reference purposes and they may be respective owner's right or trademarks. | 5/23/2013 7:58:38 PM

Use DATEPART Function as a LIKE operator.

More codes snippets