Please support our MS SQL advertiser: Programming Forums
Views: 4689 | Replies: 2
 |
•
•
•
•
| |
•
•
Join Date: Nov 2005
Posts: 1
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
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!
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
Location: Dubai,UAE
Posts: 36
Reputation:
Rep Power: 4
Solved Threads: 0
Light Poster
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
if is wht u wnat get back to me, i will give u the example
•
•
Join Date: Aug 2008
Posts: 6
Reputation:
Rep Power: 0
Solved Threads: 1
Newbie Poster
Hello,
This expression give you only the time.
I hope this help you.
This expression give you only the time.
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
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Hybrid Mode