Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
ASP.Net Dropdown with Month Day Year Please help RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Basically i mean i did created 3 columns in my database namely month, day, year but the problem is how can i SQL Query show them in gridview as 02-02-2013 since what i tried is something like (SELECT MONTH +'/'+ DAY+'/'YEAR ) But its not a date further more i need to do some graphs which need to be written in SQL .

    The date indicated below would be the date 02-02-2013, But since now i have seperated 3 colums with Month, Day and year how would i go about it that i would have just one query with all the information just as needed!!!

    Code

    WHERE (Date< GETDATE() - 7) 

    Please help i am in a soup of mess

    • Moved by Youen Zen Thursday, June 20, 2013 8:19 AM
    Tuesday, June 4, 2013 12:37 PM

Answers