July 01, 2002 05:01 PM

Manipulate and Calculate

Rating: (0)
SQL Server Magazine
InstantDoc ID #25433
Access and work with your datetime data
It might take a while for you to fully grasp how to enter, store, and display datetime data, but knowing how to effectively use dates and times to meet your business needs makes the effort worthwhile. I discussed the basics of datetime data types in "The Datetime Dilemma," June 2002, InstantDoc ID 25173, and its sidebar "Just in Time," InstantDoc 25174. However, you also need to know how to access and manipulate the components of ...

...This article is for paid Professional Members only.

Already a Professional Member? Please log in now:

NOT A PROFESSIONAL MEMBER? YOU CHOOSE:

Professional Membership

Monthly

Annual

VIP Membership

Monthly

Annual

Add a Comment

Looks like you are doing comments aboutBOL.
A boring article for anyone who already did the homework and read the BOL.

Regards.

Marcos3/13/2009 12:28:58 PM


Very useful article, provides information on date format and date related function. In real life scenario I have stumble into this problem.

Thirendra4/25/2007 2:09:21 PM


not usefule, what i really want is to get the date part of datetime in date form so that localization issues can be handled on client side

Anonymous User 12/3/2004 9:03:19 PM


You must log on before posting a comment.

Are you a new visitor? Register Here
GOOGLE LINKS
SPONSORED LINKS
FEATURED LINKS