2
shouts
spam Shout it Mute it

Convert date to different date string using Convert function of ms sql server 2005
posted by sangam100sangam100 228 days, 15 hours, 22 minutes ago
Friday, June 26, 2009 12:56:55 PM GMT
Convert date to different date string using Convert function of ms sql server 2005

Many times we need to convert datetime to different strings representing date, varying from 2009/06/2009 to June 26, 2009, and so on. Microsoft sql server 2005 can do the job for us! I had the same need some time ago, and sql server did this for me. (By the way, don't we programmers often find it irritating to have datetime representations different in different data base providers and different programming languages? Yes. Exactly here is what I am pointing towards what sql server 2005 can do for us. Follow the rest of this article for the magic!)

This is the syntax: ......

category: SQL | clicked: 8 | | source: dotnetspidor.blogspot.com | show counter code

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

To post your comment please login or signup