SANDEEP YADAV

"Nothing is impossible, the word itself says "I'm possible"!"

Pages

  • Home
  • About Me
  • VB.NET
  • SQL
  • Contact Us

Wednesday, October 23, 2013

CONVERT function gets date from SQL Server DateTime Column

SELECT CONVERT(CHAR(10), (field name), 101) FROM (table name)
Posted by Sandeep Yadav 95 60 554 552 at 4:24 AM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Newer Posts Older Posts Home
Subscribe to: Posts (Atom)

Show

  • SQL
  • vb.net

Blog

  • ►  2012 (28)
    • ►  January (8)
      • ►  Jan 03 (1)
      • ►  Jan 05 (2)
      • ►  Jan 06 (2)
      • ►  Jan 09 (1)
      • ►  Jan 13 (1)
      • ►  Jan 20 (1)
    • ►  February (7)
      • ►  Feb 07 (1)
      • ►  Feb 14 (1)
      • ►  Feb 15 (1)
      • ►  Feb 17 (1)
      • ►  Feb 20 (1)
      • ►  Feb 28 (1)
      • ►  Feb 29 (1)
    • ►  March (3)
      • ►  Mar 03 (1)
      • ►  Mar 24 (1)
      • ►  Mar 29 (1)
    • ►  April (5)
      • ►  Apr 23 (1)
      • ►  Apr 28 (1)
      • ►  Apr 30 (3)
    • ►  May (4)
      • ►  May 01 (1)
      • ►  May 02 (1)
      • ►  May 14 (1)
      • ►  May 21 (1)
    • ►  June (1)
      • ►  Jun 07 (1)
  • ▼  2013 (48)
    • ►  February (1)
      • ►  Feb 19 (1)
    • ►  April (11)
      • ►  Apr 05 (4)
      • ►  Apr 07 (1)
      • ►  Apr 08 (1)
      • ►  Apr 09 (2)
      • ►  Apr 10 (1)
      • ►  Apr 27 (2)
    • ►  May (9)
      • ►  May 03 (1)
      • ►  May 04 (1)
      • ►  May 07 (1)
      • ►  May 09 (1)
      • ►  May 12 (1)
      • ►  May 13 (1)
      • ►  May 27 (1)
      • ►  May 29 (1)
      • ►  May 30 (1)
    • ►  June (2)
      • ►  Jun 01 (1)
      • ►  Jun 06 (1)
    • ►  July (2)
      • ►  Jul 04 (1)
      • ►  Jul 29 (1)
    • ►  August (3)
      • ►  Aug 02 (1)
      • ►  Aug 12 (1)
      • ►  Aug 23 (1)
    • ►  September (3)
      • ►  Sep 07 (1)
      • ►  Sep 16 (1)
      • ►  Sep 17 (1)
    • ▼  October (6)
      • ►  Oct 18 (1)
      • ▼  Oct 23 (1)
        • CONVERT function gets date from SQL Server DateTim...
      • ►  Oct 25 (2)
      • ►  Oct 28 (1)
      • ►  Oct 30 (1)
    • ►  November (5)
      • ►  Nov 14 (1)
      • ►  Nov 16 (1)
      • ►  Nov 25 (1)
      • ►  Nov 26 (1)
      • ►  Nov 28 (1)
    • ►  December (6)
      • ►  Dec 02 (1)
      • ►  Dec 04 (1)
      • ►  Dec 11 (1)
      • ►  Dec 19 (1)
      • ►  Dec 20 (1)
      • ►  Dec 26 (1)
  • ►  2014 (15)
    • ►  January (1)
      • ►  Jan 31 (1)
    • ►  February (1)
      • ►  Feb 12 (1)
    • ►  March (5)
      • ►  Mar 11 (2)
      • ►  Mar 22 (1)
      • ►  Mar 24 (1)
      • ►  Mar 29 (1)
    • ►  April (2)
      • ►  Apr 02 (1)
      • ►  Apr 04 (1)
    • ►  July (4)
      • ►  Jul 04 (1)
      • ►  Jul 17 (1)
      • ►  Jul 29 (1)
      • ►  Jul 30 (1)
    • ►  August (1)
      • ►  Aug 13 (1)
    • ►  December (1)
      • ►  Dec 26 (1)
  • ►  2015 (1)
    • ►  December (1)
      • ►  Dec 19 (1)

Sandeep Yadav

My photo
Amethi , Uttarpradesh, India
View my complete profile

Followers

Feedjit

People Visited

Counter
Powered by aashartechnology. Simple theme. Powered by Blogger.