Extracting only date from Sqlserver Excluding time

Posted by Self-innovator under ASP.NET on 12/30/2011 | Points: 10 | Views : 797 | 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

What technologies I will need after add DLL as reference to windows form (1)Updated
How to convert mvc projects to dll to reuse inside windows form (0)
Improper Neutralization of Special Elements used in an SQL Command ('SQL Injection') in the below c (0)
XLSM file convert to PDF file ,C#.NET (2)
CSV file convert to pdf file (1)
how fill dropdownlist on radiobutton selection in MVC 4 (0)
how to check the control id in windows application? (0)
How to resolve this Query (1)
More ...