Link to home
Start Free TrialLog in
Avatar of vicomin
vicominFlag for United States of America

asked on

format sql date

I have a sql tbl with a column named/data type - start(datetime, not null)
data is like this: 2007-08-31 00:00:00.000

I run this sql stmt - convert(date, start, 110) as 'Open Date'
returns 2007-08-31

but I want it as 8/31/2007

and I have a asp.net page that this data is displayed in a gridview and it is reported as: 8/31/2007 12:00:00 AM

Help?
ASKER CERTIFIED SOLUTION
Avatar of pateljitu
pateljitu
Flag of Canada image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Mlanda T
Mlanda T
Flag of South Africa image
Here is some greate date format advice: http://www.sql-server-helper.com/tips/date-formats.aspx
Avatar of veenaravind
veenaravind
Flag of India image
Hi,

For SQL use "convert(varchar, start, 101)" as suggested by pateljitu.

For asp.net, use 

 DateTime dt = new DateTime(2011, 3, 12);

        txt1.Text = String.Format("{0:MM/dd/yyyy}", dt);

Open in new window


Hope this helps.

Thanks!
Avatar of Rose Babu
Rose Babu
Flag of India image
Hi,

Some SQL date formats are here

http://www.sql-server-helper.com/tips/date-formats.aspx

And Have a look on the comments in the below question too

https://www.experts-exchange.com/questions/27040642/Convert-DateTime-value.html

Hope this may help you.