Monday 28 January 2013

Select only date part from datetime in sql server

You can achieve this in following way:

select firstName,lastName,CONVERT(VARCHAR(10),DOB,111)as DOB,email,contact from TableName

0 comments:

Post a Comment


                                                            
 
Design by Abhinav Ranjan Sinha