Get only Time from DateTime column using SQL query using SQL Server 2005 and 2008

Question

1.00/5 (1 vote)

See more:

SQL-server-2000

SQL-Server-2005

, +

CSS

I want to get only Time from DateTime column using SQL query using SQL Server 2005 and 2008 Default output:

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


I'd like this output:
AttDate                Time
==
2011-02-09 13:09:00    13:09
2011-02-09 14:10:00    14:10

Posted 8-Apr-13 1:14am

BindassFrind

Updated 19-Sep-22 19:38pm

Add a Solution

8 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Anand Arul K · Answer 1 · 2013-04-08T22:43:00

Solution 6

in Sqlserver2008:

Select cast(your Column as time) [time]
from yourtable

Posted 8-Apr-13 22:43pm

Anand Arul K

Vani Kulkarni · Answer 2 · 2013-04-08T01:25:00

Solution 2

Check this link:
sql-server-get-time-in-hourminute-format-from-a-datetime-get-date-part-only-from-datetime/[^]

Posted 8-Apr-13 1:25am

Vani Kulkarni

Naz_Firdouse · Answer 3 · 2013-04-08T01:46:00

Solution 5

SQL

SELECT (getdate()),substring(CONVERT(VARCHAR, GETDATE(), 108),0,6) AS Time

Posted 8-Apr-13 1:46am

Naz_Firdouse

Updated 8-Apr-13 4:37am

v3

Comments

Naz_Firdouse 9-Apr-13 0:54am

what's wrong in my answer? why downvote?

PRAKASH9 · Answer 4 · 2013-04-08T01:20:00

Solution 1

use this

SQL

Select AttDate,RIGHT(CONVERT(VARCHAR, AttDate, 100),7) as Time From Tablename

Posted 8-Apr-13 1:20am

PRAKASH9

_Amy · Answer 5 · 2013-04-08T01:31:00

Try this:

SQL

SELECT CONVERT(VARCHAR(5),GETDATE(),108) AS Time
--From your table
--Assume AttDate is DateTime column of Table1
SELECT AttDate, CONVERT(VARCHAR(5), AttDate,108) AS Time FROM Table1

OR

SQL

SELECT LTRIM(RIGHT(CONVERT(VARCHAR(20), GETDATE(), 100), 7)) AS Time
SELECT AttDate, LTRIM(RIGHT(CONVERT(VARCHAR(20), AttDate, 100), 7)) AS Time FROM Table1

--Amit

Member 2707515 · Answer 6 · 2013-04-08T01:44:00

Solution 4

SQL

SELECT CONVERT(VARCHAR, GETDATE(), 108) AS Time

In format hh:mm:ss

Posted 8-Apr-13 1:44am

Member 2707515

Updated 8-Apr-13 4:35am

v2

kirthiga S · Answer 7 · 2018-05-24T19:37:00

Solution 8

select AttDate,convert(time,AttDate)Time from TableName

Posted 24-May-18 19:37pm

kirthiga S

Member 13560343 · Answer 8 · 2022-09-19T19:38:00

Solution 9

Convert(varchar,getdate(),114)

Posted 19-Sep-22 19:38pm

Member 13560343