473,473 Members | 1,719 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

Query Req:of having same days

27 New Member
in a table having the fields of starttime & endtime ,I want to fetch only the records having starttime & endtime of same days.
Mar 25 '11 #1
1 1213
gpl
152 New Member
Strip off the time and test for equality - look at converting to a string
Mar 25 '11 #2

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

Similar topics

1
by: Glenn | last post by:
Searching through google groups, I have not found anyone able to modify the query string of a request. I was hoping to make the query string as short as possible so that a search with many...
1
by: Torrent | last post by:
The Following is an Error I am getting using VS.NET 2003. When I bind the XML and XSLT Document together in Internet Explorer it works fine. However when I attempt to Load the File with the...
3
by: Torrent | last post by:
When Trying to Load an XSLT File with the XslTransform i got a rather annoying Exception being thrown "System.Xml.XPath.XPathException: XsltContext is needed for this query because of an unknown...
2
by: Seth Delaney | last post by:
I have a form with multiple unbound text boxes which serves as a "search form". I can enter my search parameters in the various boxes as needed and click okay. My records are then filtered to...
2
by: plau011 | last post by:
First thanks in advance for your help. I am trying to do a query and am not sure if this is possible. I have a table called Extensions: ID Ext CDate 1 100 2/2/2005 2 101 2/3/2005 3 ...
1
by: MR | last post by:
Is there a limitation to the number of columns you can define in the Query Builder of a data adapter? it seems the limit is around 96. i know i can split the query into two parts, but then it would...
2
by: Prem | last post by:
Apparently the query analyser of sql server does not recognise a database with a point in it, like mail.archive.mdf I receive the following error when I use it: Server: Msg 911, Level 16,...
1
by: Thyagu | last post by:
Hi, Is there a way to findout the query plan of the executing process using the SPID/KPID information. Thanks in advance, Thyagu.D
0
Vasuki Masilamani
by: Vasuki Masilamani | last post by:
Hi, Could anyone please help me with a query to get the number of working days in a month. Thanks in advance. Vasuki.
1
by: EasyTarget | last post by:
Hello All: I am trying to write a query to determine the number of consecutive days that a conference room is available. The conference room is reserved for an entire day. People want to reserve...
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,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
1
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
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?
0
muto222
php
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.