•
•
•
•
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 397,627 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 2,370 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: 1101 | Replies: 1
•
•
Join Date: Jul 2005
Posts: 91
Reputation: 
Rep Power: 4
Solved Threads: 0
Junior Poster in Training
Hey guys,
I am trying to design a query that will return all the records based on a single date but because of the date/time data type in MS SQL 2005 it defaults to the date and the time 00:00:00 which will return no records for me.
Is it possible to ignore the time part in the select statement?
Thanks.
I am trying to design a query that will return all the records based on a single date but because of the date/time data type in MS SQL 2005 it defaults to the date and the time 00:00:00 which will return no records for me.
Is it possible to ignore the time part in the select statement?
Thanks.
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb MS SQL Marketplace
Threaded Mode- Did my computer die? (Troubleshooting Dead Machines)
- Seemingly Simple Issue (MS SQL)
- Struggling with Captcha (PHP)
- Help with dates please (ASP)
- Unable To Right Click Desktop (Viruses, Spyware and other Nasties)
- New to C and needing some guidance (C)
- How to counta repeat records (Visual Basic 4 / 5 / 6)
- Hotmail Login (Windows NT / 2000 / XP / 2003)
- Windows Media Player bitten by virus (Windows 9x / Me)
- My site is not keeping peoples intrests (Website Reviews)
Other Threads in the MS SQL Forum
- Previous Thread: Simple Question PLease URGENT
- Next Thread: Types of JOINS
