How to get only Time from GetDate()

Question

0.00/5 (No votes)

See more:

How to get only Time from GetDate(). Format is hh:mm PM/AM.

Finally my requirement is to get Random Time between 10.00 AM to 8.30 PM.

Posted 9-Sep-11 3:10am

LebneizTech

Updated 9-Sep-11 3:20am

LittleYellowBird

v2

Add a Solution

3 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)

Wendelius · Answer 1 · 2011-09-09T03:19:00

Solution 1

you can cast the date to a time. For example:

SQL

select cast(getdate() as time)

Posted 9-Sep-11 3:19am

Wendelius

Comments

LebneizTech 9-Sep-11 9:28am

not working

Wendelius 9-Sep-11 9:37am

Do you get an error or why it isn't working? Also what version of SQL Server are you using?

Corporal Agarn 9-Sep-11 12:28pm

Which version of SQL do you have. TIME is a new data type.

Wendelius 9-Sep-11 14:22pm

2008 R2, time data type was introduced in version 2008

LebneizTech 12-Sep-11 6:30am

Sir, I am using SQL 2000/2005 that's why it shows error

Corporal Agarn · Answer 2 · 2011-09-09T06:27:00

Solution 2

Use

CONVERT( VARCHAR(8), Getdate(), 108)

Lookup CAST and CONVERT

Posted 9-Sep-11 6:27am

Corporal Agarn

M_Mogharrabi · Answer 3 · 2011-09-09T21:00:00

Solution 3

You can use TimeOfDay property to get the time of a special date:

C#

 DateTime Date = new DateTime(Your datetime);
String Time = Date.TimeOfDay.ToString();

Posted 9-Sep-11 21:00pm

M_Mogharrabi