How to get Time from DateTime format in SQL

0 votes

I want to use a SQL query using SQL Server 2005 and 2008 to get simply the Time from the DateTime column. Default output:

AttDate                   
==
2011-02-09 13:09:00    
2011-02-09 14:10:00    

I want to have this output:

AttDate                Time 
==
2011-02-09 13:09:00    13:09
2011-02-09 14:10:00    14:10

Can someone please help me with this?

Aug 15 in Database by Kithuzzz
• 11,040 points
31 views

No answer to this question. Be the first to respond.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.

Related Questions In Database

0 votes
0 answers

How to get current datetime in SQL?

In order to add the current date ...READ MORE

Aug 30 in Database by Kithuzzz
• 11,040 points
34 views
0 votes
0 answers
0 votes
1 answer

How to format datetime in SQL SERVER

In SQL Server 2012 and up you ...READ MORE

answered Sep 18 in Database by narikkadan
• 18,480 points
14 views
0 votes
1 answer

how to change format of date from mm/dd/yyyy to dd-mmm-yyyy in MS Excel

First, pick the cells that contain dates, ...READ MORE

answered Apr 11 in Database by gaurav
• 18,960 points
27,844 views
0 votes
0 answers

How can I set a custom date time format in Oracle SQL Developer?

Date values are shown in Oracle SQL ...READ MORE

Aug 12 in Database by Kithuzzz
• 11,040 points
29 views
0 votes
0 answers

How to convert SQL Server's timestamp column to datetime format

Is there a simple way to convert ...READ MORE

Aug 21 in Database by Kithuzzz
• 11,040 points
96 views
0 votes
1 answer

SQL Server string to date conversion

Try this Cast('7/7/2011' as datetime) And Convert(DATETIME, '7/7/2011', 101) See CAST and ...READ MORE

answered Sep 16 in Database by narikkadan
• 18,480 points
24 views
0 votes
0 answers

Selecting COUNT(*) with DISTINCT

In SQL Server 2005, I have a ...READ MORE

Feb 14 in Database by Neha
• 8,920 points
105 views
0 votes
1 answer
0 votes
0 answers

Simple DateTime sql query

How do I query the DateTime database ...READ MORE

Aug 12 in Database by Kithuzzz
• 11,040 points
20 views
webinar REGISTER FOR FREE WEBINAR X
Send OTP
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP