MS SQL

MS SQL RSS

I just need TIME not Date.

Please support our MS SQL advertiser: Intel Parallel Studio Home

•

Join Date: Nov 2005

Posts: 1

Reputation: jgoering is an unknown quantity at this point

Solved Threads: 0

jgoering

Offline

Newbie Poster

I just need TIME not Date.

Nov 6th, 2005

I'm working on a project that just needs to know that its 08:00 or 14:01. I dont need or want to store anything about date.

When I store the time and then try to check it against the current time I'm runnig into problems.

where (timeofevent = Convert(char(19),current_timestamp))

this doesnt work because Convert(char(19),current_timestamp
returns Nov 6 2005 6:39PM when what I need is 6:39PM or 18:39.

I need help getting the current time in that format.

THANKS!

•

Join Date: Nov 2005

Posts: 40

Reputation: noman78 is an unknown quantity at this point

Solved Threads: 0

noman78

Offline

Light Poster

Re: I just need TIME not Date.

Nov 23rd, 2005

u can use combination of SubString and instr function and can extract time from the date-time stamp
if is wht u wnat get back to me, i will give u the example

•

Join Date: Aug 2008

Posts: 6

Reputation: AntonioGK is an unknown quantity at this point

Solved Threads: 1

AntonioGK

Offline

Newbie Poster

Re: I just need TIME not Date.

Aug 13th, 2008

Hello,

This expression give you only the time.

 Help with Code Tags 
 MS SQL Syntax (Toggle Plain Text) 
CONVERT (varchar, GETDATE(), 114)
-- this is the result
-- 10:24:55:640
CONVERT (varchar, GETDATE(), 114)
-- this is the result
-- 10:24:55:640