Extracting only date from Sqlserver Excluding time

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

Why do we need default column values in SQL Server? (1)Updated
Can we create Primary Key on more than one column? (1)Updated
Integrated Web Service with Mule ESB (0)Updated
Display html and data on pageload in mvc using angular js (0)New
Is it necessary to have a Primary Key on the table? (1)Updated
How can i use two app.js files in single AnuglarJS application (0)
Can we have a functionality of Primary Key without creating a Primary Key? (1)
When to use Interface and when to use Abstract? (1)
More ...