I just need TIME not Date.

Expand Post »

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!

Similar Threads

Getting time from system clock in nanoseconds in C++
Display client's PC Date & Time in ASP.NET
Convert time stamp to date using php in PHP
Time for a Clean Install of XP? in Windows tips 'n' tweaks
How to Get Last Accessed/Created/Modified File Date and Time in C

jgoering

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

1 posts
since Nov 2005

Permalink

Nov 23rd, 2005

Re: I just need TIME not Date.

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

noman78

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

40 posts
since Nov 2005

Permalink

Aug 13th, 2008

Re: I just need TIME not Date.

Hello,

This expression give you only the time.

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

I hope this help you.

Last edited by AntonioGK; Aug 13th, 2008 at 2:28 pm. Reason: Add Result

AntonioGK

Reputation Points: 12

Solved Threads: 1

Newbie Poster

Offline

6 posts
since Aug 2008

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in MS SQL Forum Timeline: Reading logs in MS SQL Server 2000

Next Thread in MS SQL Forum Timeline: SQL Join query not working correctly

DaniWeb Message

Cancel Changes

User Name
Password