skip to main | skip to sidebar

Sanjeewa'S Tech Page

Wednesday, September 19, 2007

Format date fome the database (not front end)

(cast(year([Due_Date]) as varchar)+'-'+cast(month([Due_Date]) as varchar)+'-'+ cast(day([Due_Date]) as varchar)) AS [Due_Date],
Posted by SS - LK at 11:42 PM

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Blog Archive

  • ►  2010 (9)
    • ►  October (1)
    • ►  May (2)
    • ►  April (3)
    • ►  February (2)
    • ►  January (1)
  • ►  2009 (29)
    • ►  December (2)
    • ►  October (2)
    • ►  August (3)
    • ►  July (3)
    • ►  June (3)
    • ►  May (3)
    • ►  April (5)
    • ►  January (8)
  • ►  2008 (46)
    • ►  November (1)
    • ►  October (14)
    • ►  August (11)
    • ►  May (7)
    • ►  April (1)
    • ►  March (2)
    • ►  February (10)
  • ▼  2007 (33)
    • ►  December (1)
    • ►  November (7)
    • ►  October (11)
    • ▼  September (12)
      • using a populated dataset (one row of data) displa...
      • Bind dorop down to dataset object easyly
      • Example of How to join 3 tables using inner join
      • Sql Query Which give ID not in another table
      • Get curent date and time formatted and display usi...
      • Format date fome the database (not front end)
      • Assign default value to a object is when assign de...
      • Implement mail functionality link using a hypelink
      • Getting Values from asp.net data grid view
      • Send the mail using Threading
      • Handling row edit Event in dataGrid
      • Format DataGrid data format without time
    • ►  July (2)
 

You like my blog?

Search This Blog

Followers