•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MS SQL section within the Web Development category of DaniWeb, a massive community of 391,868 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,503 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MS SQL advertiser:
Views: 3997 | 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: 3
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
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb MS SQL Marketplace
Linear Mode
- Getting time from system clock in nanoseconds (C++)
- Display client's PC Date & Time (ASP.NET)
- Convert time stamp to date using php (PHP)
- Time for a Clean Install of XP? (Windows tips 'n' tweaks)
- How to Get Last Accessed/Created/Modified File Date and Time (C)
- VBA Date Format (Visual Basic 4 / 5 / 6)
Other Threads in the MS SQL Forum
- Previous Thread: Run SSIS Package from VB 2005 / SMO?
- Next Thread: PHP/MS SQL Web Form administration application?
