Tutorials
Resources
Forum
Communities
Interview
Jobs
Projects
Offshore Development
Silverlight Tutorials
|
Mentor
|
Code Converter
|
Articles
|
Code Factory
|
Computer Jokes
|
Members
|
Peer Appraisal
|
IT Companies
|
Bookmarks
|
Revenue Sharing
|
Prizes & Awards
My Profile
Sign In
Register
AdSense Revenue
Active Members
Today
Deepika Harida...
(321)
SweetGhost
(267)
David Billa
(183)
Last 7 Days
Arun Jacob
(1406)
amarababu nara...
(1301)
Deepika Harida...
(1194)
more...
New Feature:
Community Sites
:
Create your own .NET community website and start earning from Google AdSense !
It's Free !
How to get date part from a datetime column
Posted Date: 06 Jun 2008 Resource Type:
Code Snippets
Category:
SQL
Posted By:
Debasmit Samal
Member Level:
Gold
Rating:
Points
: 5
The following code Select the date part from a datetime column
/* Creating a Test Table */
Create Table TestTable
(
DateColumn datetime
)
select convert(varchar,DateColumn,108) from TestTable
Responses
Author:
Kapil Dhawan
18 Jun 2008
Member Level:
Gold
Points
: 2
Hello
Nice piece of code
Thanks for sharing your knowledge with us.
I hope to see more good code from your side
This code will help lots of guys
Thanks to you
Regards,
Kapil
Feedbacks
Popular Tags
What are tags ?
Search Tags
Sign In
(No tags found.)
Post Feedback
This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must
Sign In
to post a response.
Next Resource:
working with SELECT
Previous Resource:
How to create User Defined Function in Sql
Return to Discussion Resource Index
Post New Resource
Category:
SQL
Post resources and
earn money
!
Related Resources
How to find tables with record count
How To Use Row Count in SQLserver
IF Exist vs Count
Data Dictionary Queries for SQL Server and Oracle
Simple Database Operations (INSERT, DELETE, UPDATE) using Asp.Net
dotNet Slackers
BizTalk Adaptors
Web Design
web conferencing services
Contact Us
Privacy Policy
Terms Of Use