DotNetShoutout

Welcome!

DotNetShoutout is a place where you can find the latest Microsoft .NET stories to increase your skills and share your opinions.

Enjoy participating in this community and see which other people in our industry are getting Shoutouts.

faq »

8
Shouts

Shout it

Top 10 Questions on Datetime asked in Forums

published 952 days, 5 hours, 28 minutes ago posted by

dhara 952 days, 17 hours, 41 minutes ago

There are innumerable numbers of questions asked in different forums about datetime concepts. I found so many replies using the functions such as Cast, Convert, Month () and Year () in where clause. There is a disadvantage with these functions. If the datetime column has index, these functions will not utilize the indexes properly, which often results in index scans.

category: Data | clicked: 2 | | source: beyondrelational.com | show counter code

tags: SQL Server, DateTime, TSQL

Border color:

Shout it Backcolor:

Shout it Forecolor:

Count Backcolor:

Count Forecolor:

Preview

update reset

DotNetShoutout

Welcome!

Top 10 Questions on Datetime asked in Forums

No comments yet, be the first one to post comment.

Open ID Login

Standard Login

Forgot Password?

Sign up