Extracting only date from Sqlserver Excluding time

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

how to add title in anchor using jquery (1)
Use Case, Technical/Requirement/SRS Document (1)
LINQ to SQL vs Entity Framework (1)Updated
Dependency injection in MVC and how to acomplish, constructor level interface implement (0)
Difference between select and where in linq (0)
Pperformance tuning in sql other than profiler (1)
Benefit of singleton Design pattern (0)
How to design a project (0)
More ...