473,434 Members | 1,418 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,434 software developers and data experts.

How to get a record from 15/09/2010 to 25/09/2010

plz help, i want to get all record between this date as 15/09/2010 to end date 25/09/2010.

when i am using between '15/09/2010' and '25/09/2010'
then i am getting record from 15/09/2010 to 24/09/2010, i am not getting 25/09/2010 date record.
Sep 18 '10 #1
2 1356
gpl
152 100+
Hi
The problem here is that SQL Server does not hold just dates, it records the time too

so, 15/09/2010 is midnight at the start of 15/09/2010. Fine for the start period of a query, however for 25/09/2010, it is midnight at the start of 25/09/2010, which is the same as the end of the 24th, which is why you see the results that you get. Either ask for everything up to the beginning of the next day (26/09/2010) or add in the time (23:59:59)
Sep 20 '10 #2
ck9663
2,878 Expert 2GB
Here, read this...

Good Luck!!!

~~ CK
Sep 20 '10 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

5
by: MLH | last post by:
Anyone remember how to determine a particular record's record number (Access 2.0 table question)?
0
by: htmlgeek | last post by:
I'm adding and updating records in an Access .mdb via WWW .asp page. Authored in Dreamweaver 2004 MX. Help is welcome on this one. I have a great set of pages that work fine, but it seems that...
3
by: Fuzzy.wonderdog | last post by:
Hello, I hope some one can help me, at least give me a little direction. I have the need to insert many records into the same table at once. Not very many data points (<5), but many (30+)...
1
by: Adrian | last post by:
Hi I'm lost! so please help me... I have the following code I want to simply retrieve all the record that matches the SQL statement, I want to know how many records matched and display only...
1
by: Robert | last post by:
I have a form that has a table; tblProjects; as its record source. The form is filtered, however, by two combo boxes in the header. One allows the user to select a client, the other a project for...
3
by: david | last post by:
I have following code, but I do not know where the problem is. Thank you for any help. David ----Code--- 'connection conn = New SqlConnection _ ("data source=localhost;integrated...
1
by: Peter Herath | last post by:
I have created a report using sample codes taken by the forum. one problem is that the report displays the field/column names in the table in columnar format(field names display in rows.) but i want...
1
by: Eric IsWhoIAm | last post by:
I have three tables: Courses (Key is Autonumber Course Number, also have Text Course Name); Instructors (similar fields); and Courses and Instructors (have a combination of the four fields). ...
0
by: freeskier | last post by:
Hello, Sorry for the newb question; I've spent a good amount of time trying to figure this out. I am fairly new to the Postgre world. I am currently in the process of upsizing several MS Access...
4
by: doxtor | last post by:
Dear all.. I try to make an inventory control, with FIFO(first in first out) base, but I have a problem with the next record. this is the code i make : $db = new clsDBMassimo; $product_id...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
1
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.