Ignore Date part and get time part from datetime column in sql?

Question

1.00/5 (1 vote)

See more:

C#

ASP.NET

SQL

Hi,

I have a problem, i want to use Time part from my Date Time SQL Column.

Kindly anyone please hep me!

Thanks .

Posted 12-Jul-11 2:34am

Ahsan Mirza

Add a Solution

Comments

Pong D. Panda 12-Jul-11 8:40am

You're spamming. Go back to your first post and update it, then provide a descriptive info on how do you want to attain this, or what part will it be implemented (backend, SQL, etc)

4 solutions

Solution 2

EASILY found on google. You could put this code into a Sql function if you want to:

SQL

CONVERT(char(10), MyDateTime, 101) AS [Date],
     CONVERT(varchar(2),
          CASE
               WHEN DATEPART([hour], MyDateTime) > 12 THEN CONVERT(varchar(2), (DATEPART([hour], MyDateTime) - 12))
               WHEN DATEPART([hour], MyDateTime) = 0 THEN '12'
               ELSE CONVERT(varchar(2), DATEPART([hour], MyDateTime))
          END
     ) + ':' +
     CONVERT(char(2), SUBSTRING(CONVERT(char(5), MyDateTime, 108), 4, 2)) + ' ' + 
     CONVERT(varchar(2),
          CASE
               WHEN DATEPART([hour], MyDateTime) > 12 THEN 'PM'
               ELSE 'AM'
          END
     )

Posted 12-Jul-11 2:42am

#realJSOP

Comments

[no name] 18-Jul-11 6:39am

Excellent. My 5 .

Solution 3

You can use

SELECT CONVERT(VARCHAR(10),DATE_FIELD,108)

Posted 12-Jul-11 2:42am

Reiss

Solution 1

I have placed a suggested solution here: http://www.codeproject.com/Answers/224677/How-to-get-Time-Part-from-DateTime#answer2

Posted 12-Jul-11 2:41am

Ger Hayden

Comments

Ger Hayden 12-Jul-11 14:32pm

OK, so what is wrong with this. The OP put the question up twice, and having answered it felt that a link to the original answer was in order rather than cut and paste.

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)

Emrah Taylan · Accepted Answer · 2011-07-12T02:44:00

Solution 4

SQL

SELECT     CONVERT(nvarchar(50), 'COLUMNNAME', 114) AS Time
FROM         'TABLENAME'

Posted 12-Jul-11 2:44am

Emrah Taylan