Search records based on particular Date in sql

Submit Code |

Search Codes |

Code Home |

Select  column1, column2, createdDate from tSearchTable 

where DATEPART(month, dtmCreatedDate) = 10

and DATEPART(day, dtmCreatedDate) = 26

and DATEPART(year, dtmCreatedDate) = 2012

Thanks and Regards
Madhu

Found interesting? Add this to:

| More | Bookmark It

Responses
Posted by: Jasminej \| Posted on: 10/26/2012 \| Level: Starter \| Status: [Member] \| Points: 10 \| Alert Moderator What about the performance using this method ? thank you
Posted by: T.Saravanan \| Posted on: 10/28/2012 \| Level: Silver \| Status: [Member] [MVP] \| Points: 10 \| Alert Moderator @Madhu, Is there any problem in direct condition? like "CONVERT(DATETIME, dtmCreatedDate, 101) = '10/26/2012'" Thanks, T.Saravanan
Posted by: Mohaiselva \| Posted on: 11/2/2012 \| Level: Starter \| Status: [Member] \| Points: 10 \| Alert Moderator CONVERT(DATE,dtmCreatedDate) = '2012-11-02' I think it is the best method to get the record in particular date.

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

More codes snippets

Submit Code | More ...

Search records based on particular Date in sql

Responses

More codes snippets