Sunilkumar
Member since Dec 11, 2008
- Profile: /members/275-sunilkumar.htm
- Comments: 1
Recent Blog Comments By Sunilkumar
-
Getting Only the Date Part of a Date/Time Stamp in SQL Server
Posted on Jun 6, 2008 at 7:23 AM
You can use SELECT CONVERT(CHAR(10),GETDATE(),103) from TABLENAME You will get month/day/year format. If you want different format change 103 to 101 or some other from 101 to 113... read more »