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
Appukuttan
(94)
Abhi
(72)
Babu Akkandi
(63)
Last 7 Days
Appukuttan
(619)
Babu Akkandi
(470)
divya
(321)
more...
New Feature:
Community Sites
:
Create your own .NET community website and start earning from Google AdSense !
It's Free !
Get Time alone from datetime field
Posted Date: 10 May 2008
Resource Type:
Code Snippets
Category:
SQL
Author:
NP Senthil kumar
Member Level:
Gold
Rating:
Points
: 10
Use the following query to get the Time part from the datetime field
select right(getdate(),7)
Responses
Author:
Jaya Kumar
12 May 2008
Member Level:
Gold
Points
: 2
SELECT CONVERT(VARCHAR,GETDATE(),101) AS DATE
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:
Find Difference between two dates in T-SQL
Previous Resource:
Create a stored procedure that retrieves a row by id
Return to Discussion Resource Index
Post New Resource
Category:
SQL
Post resources and
earn money
!
Related Resources
GRANT permission to ALL stored procedures
How to join tables from different servers?
How to find tables with record count
How to use stored procedure to take large Text input and populate in a table
Get List of Columns,views,Tables,function........
dotNet Slackers
BizTalk Adaptors
Web Design
Contact Us
Privacy Policy
Terms Of Use