Extracting only date from Sqlserver Excluding time

Posted by Self-innovator under ASP.NET on 12/30/2011 | Points: 10 | Views : 832 | Status : [Member] | Replies : 1

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

Hi friends pls find soln..
I want to retrieve only date and to disp in my asp app from stored datetime in my databsae sql server ...
whan i make use of this query

select CONVERT(varchar(10),getdate(),111)

retrieves current date not the stored date of db..

Join Hands Change lives
Thanks & Regards
Straight Edge Society

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Prabhakar on: 12/30/2011 [Member] [MVP] Starter | Points: 25

0	hello Try this . . select CONVERT(varchar(8), OrderDate, 112) as OrderDateOnly Best Regard's Prabhakar Self-innovator, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts

Index and length must refer to a location within the string. Parameter name: length (0)New
How can I use Remote Validation with entity framework Code First Approach in ASP .Net MVC. (0)
how can i optimize query (0)
what i write inside loop to display similar item code on datagridview and insert different itemcode (0)
Need and Use Cases of .Net Core (0)
read excel file and insert into oracle database (3)
How to know which event fires from start of windows form running visual studio 2015 (1)
editmode not working in angularjs (0)
More ...