Select Records between Date/Time & Date/Time?

Why is my location on the world map determined incorrectly?

Hello Guest

• Login
• Register…
• Start blog

• Who, Where, When
• What can I do?
• What to Read?

• Polls
• Avatars
• Interests

• Cities and Countries
• Random blog
• Users search

• Search
• Games
• Tests
• QAIX

• Сообщества
• Talxy Chat
• Horoscope
• Online

Зарегистрируйся!

QAIX > ASP web-programming > Select Records between Date/Time & Date/Time? 13 October 2008 09:37:07

Recent blog posts:

_4_
…

mego day!
:-O yesss I today went for a walk from a 6 morning! it super! so merrily that pipec!

Everybody is a book
Everybody is a book, parents are our publishing houses, and our publication time on birthday, the ID…

boring..boring...boring :-|…
boring..boring...boring :-| where people? bitchs...not abandon me one…

here so quietly and boring! on…
here so quietly and boring! on beone merrier far! well but I can sit in a quiet.... and not who by the…

Transfer iTunes Library to Zune
If you have moved from Apple iPod to Microsoft Zune, you probably have some songs that you purchased…

hello!
hello!I here new! interestingly me what people dwell on this site... I search friends from the command…

Routes on Sale!
Looking for great Quality/Competitive Rates???? Breezecom FZC is offering: PAKISTAN! CLI…

Hello!
Hello!

How to rip DVD and convert…
You may have at hand many fantastic DVD movies and video files, which you definitely love very much…

Forums:

topic feeds

• QAIX all topics, blogs and comments

• PHP web-programming

• Perl web-programming

• ASP web-programming

• Visual Basic Programming

• .Net Development

• C/C++ Programming

• Java Programming

• Javascript web-programming

• Apache HTTP Server

• Web-design

• Web-hosting, dedicated, colocation

• HTML web-programming

• XML development

• General Web-programming

• Content Management Systems

• ColdFusion

• Search Engine Optimization

• Hardware

• Software, Computer Help

• MySQL database development

• PostgreSQL database development

• MS Access database development

• Oracle database development

• MS SQL database development

• Informix database development

• Buy / Sell

• Open discussion

• Anonymous

Discuss:

Select Records between…
I've built a Point-of-Sale using "classic" asp (it's what I know) and I'm trying to get daily…

Borwser prompts for…
I have put together a very simple internal web site that runs on Windows 2003 Server. Anonymous access…

Possible to include SSI in ASP…
Hi, We want to include some SSI in our ASP pages, but where the SSI is located on a different server…

text wait or hourglass
Hi Can someone please help me with the following: I have an ASP-page where a query runs, it…

Recent forum topics:

r24799 - docs/Perl6/Spec
Author: particle Date: 2009-01-07 20:53:32 +0100 (Wed, 07 Jan 2009) New Revision: 24799 Modified…

r24798 - docs/Perl6/Spec
Author: particle Date: 2009-01-07 20:42:33 +0100 (Wed, 07 Jan 2009) New Revision: 24798 Modified…

Writing to an iterator
I was just reading through S07, and it occurred to me that if one wanted to, one could handle stacks and…

ServiceController status…
This is a repost from CLR, doesn't seem like there is much activity over on that list. This isn't…

Recent forum comments:

RE: NEW NEOPOINT GENERATOR v2…
Is it really that hard to hack neopets? I figure someone must of done something about that O:

RE: Re: What happened with…
$ svn info lib/Apache2/Reload.pm Path: lib/Apache2/Reload.pm Name: Reload.pm URL…

RE: Can I have multiple child divs?
I don't understand your question. The button bar appears stable to me. -- Murray MVP Expression Web…

RE: Can I have multiple child divs?
It is related to the white space issue at the bottom. If I try to move the tables up to get rid of the…

RE: Frustrated, Frontpage…
Sixbells;9207716 Wrote: I would use a decent package such as Dreamweaver or if you cant afford it go…

RE: Frustrated, Frontpage…
and that would fix it, eh? -- ~~~~~~~~~~~~~~~~~~ Rob Giordano Microsoft MVP Expression…

RE: Frustrated, Frontpage…
I will re-write it with nested tables, a good do over usually results in better code anyway. But one…

RE: Frustrated, Frontpage…
Don't use the draw table tool. That will add height attributes to everything (tables and table cells)…

RE: change text color
Use the Date Diff functionSee…

RE: Drop down is not displaying…
I have talked to my boss and we do not want the top frame larger, so we are going to re-develop the…

Moderators:

Administrator
Protorioris


Select Records between Date/Time & Date/Time?
Greg 13 October 2008 09:37:07
	I've built a Point-of-Sale using "classic" asp (it's what I know) and I'm trying to get daily sales totals. The problem is sales for the day do not stop at 11:59pm. What is a clean way to select the records from say 8:00am at start of business to 4:00am the next morning? I should be able to figure this out, but I think I've been looking at this too long... Any help would be appreciated! Thanks, Greg
		Add comment


Bob Barrows 4 September 2008 00:11:42 [ permanent link ]
	Greg wrote: I've built a Point-of-Sale using "classic" asp (it's what I know) and I'm trying to get daily sales totals. The problem is sales for the day do not stop at 11:59pm. What is a clean way to select the records from say 8:00am at start of business to 4:00am the next morning? I should be able to figure this out, but I think I've been looking at this too long... Any help would be appreciated! It really depends on how the data is stored. -- Microsoft MVP -- ASP/ASP.NET Please reply to the newsgroup. The email account listed in my From header is my spam trap, so I don't check it very often. You will get a quicker response by posting to the newsgroup.
		Add comment


Greg 4 September 2008 00:17:48 [ permanent link ]
	"Bob Barrows [MVP]" <reb01501@NOyahoo.SPAMcom> wrote in message news:OWvVrmgDJHA.936@TK2MSFTNGP03.phx.gbl... Greg wrote: I've built a Point-of-Sale using "classic" asp (it's what I know) and I'm trying to get daily sales totals. The problem is sales for the day do not stop at 11:59pm. What is a clean way to select the records from say 8:00am at start of business to 4:00am the next morning? I should be able to figure this out, but I think I've been looking at this too long... Any help would be appreciated! It really depends on how the data is stored. -- Microsoft MVP -- ASP/ASP.NET Please reply to the newsgroup. The email account listed in my From header is my spam trap, so I don't check it very often. You will get a quicker response by posting to the newsgroup. The date/time stamps are stored as such.
		Add comment


Greg 4 September 2008 00:30:51 [ permanent link ]
	"Greg" <greg@redseahookah.com> wrote in message news:1107D1CE-324D-4F39-A723-F42D62CD70CF@microsoft.com... "Bob Barrows [MVP]" <reb01501@NOyahoo.SPAMcom> wrote in message news:OWvVrmgDJHA.936@TK2MSFTNGP03.phx.gbl... Greg wrote: I've built a Point-of-Sale using "classic" asp (it's what I know) and I'm trying to get daily sales totals. The problem is sales for the day do not stop at 11:59pm. What is a clean way to select the records from say 8:00am at start of business to 4:00am the next morning? I should be able to figure this out, but I think I've been looking at this too long... Any help would be appreciated! It really depends on how the data is stored. -- Microsoft MVP -- ASP/ASP.NET Please reply to the newsgroup. The email account listed in my From header is my spam trap, so I don't check it very often. You will get a quicker response by posting to the newsgroup. The date/time stamps are stored as such. Seperately that is...
		Add comment


Bob Barrows 4 September 2008 02:50:12 [ permanent link ]
	Greg wrote: "Greg" <greg@redseahookah.com> wrote in message news:1107D1CE-324D-4F39-A723-F42D62CD70CF@microsoft.com... "Bob Barrows [MVP]" <reb01501@NOyahoo.SPAMcom> wrote in message news:OWvVrmgDJHA.936@TK2MSFTNGP03.phx.gbl... Greg wrote: I've built a Point-of-Sale using "classic" asp (it's what I know) and I'm trying to get daily sales totals. The problem is sales for the day do not stop at 11:59pm. What is a clean way to select the records from say 8:00am at start of business to 4:00am the next morning? I should be able to figure this out, but I think I've been looking at this too long... Any help would be appreciated! It really depends on how the data is stored. The date/time stamps are stored as such. Seperately that is... More details please: database type and version table name fieldnames and datatypes It helps to include a few rows of sample data followed by desired results -- Microsoft MVP - ASP/ASP.NET Please reply to the newsgroup. This email account is my spam trap so I don't check it very often. If you must reply off-line, then remove the "NO SPAM"
		Add comment


Old Pedant 9 September 2008 05:36:01 [ permanent link ]
	"Greg" wrote: I've built a Point-of-Sale using "classic" asp (it's what I know) and I'm trying to get daily sales totals. The problem is sales for the day do not stop at 11:59pm. What is a clean way to select the records from say 8:00am at start of business to 4:00am the next morning? I should be able to figure this out, but I think I've been looking at this too long... You ever figure this out??? It's not hard, but you goofed by putting the data and time into separate fields in the DB. Now you just have to lump them back together. And what do you do about times between 4AM and 8AM???? Yeah, I know...the store is closed. Want to be that someday somebody sells something at 4:03 AM?? Anyway, fortunately in Access you can just add a time to a date to get a date/time value. And I'm going to assume that your "days" really run from 8AM to 7:59:59 AM. SO... SELECT DATEVALUE(sales_date+sales_time-1/3) AS theDate, SUM(sales_amount) AS total FROM sales_table GROUP BY DATEVALUE(sales_date+sales_time-1/3) ORDER BY 1 Now, that's a hacky trick: In Access, dates and times are represented as the number of days since 12/30/1899. Dates are the whole integer number of days. Times are the fractional part of a day. So when I do -1/3 I am subtracting 1/3 of a day--which is 8 hours--from the sum of the date and time. That is, I am adjusting the effective date backwards by 8 hours. If this really offends you sensibilities, you can use DATEADD instead: DATEVALUE( DATEADD( 'h', -8, sales_date + sales_time ) ) But next time, don't store the date and time in separate fields in the DB. In any DB but Access, you'd make the whole thing a lot harder.
		Add comment


Ken 4 October 2008 00:04:57 [ permanent link ]
	I like to use the DataDiff function in SQL SELECT * FROM table WHERE the_time_of_sale = (SELECT Max(time_of_sale) from table WHERE DATEDIFF(hh,the_time_of_sale, '" & rsFirstOfSession("date or whatever") & "' ) > -27AND DATEDIFF(hh,the_time_of_sale, '" & rsFirstOfSession("date or whatever") & "' ) > -3);"' So that would give you everything not more than 27 before hours from the date entered and not more than 3 hours ahead. And that first of session could be today's date or user input whatever. On Sep 3, 2:52pm, "Greg" <g...@redseahookah.com> wrote: I've built a Point-of-Sale using "classic" asp (it's what I know) and I'm trying to get daily sales totals. The problem is sales for the day do not stop at 11:59pm. What is a clean way to select the records from say 8:00am at start of business to 4:00am the next morning? I should be able to figure this out, but I think I've been looking at this too long... Any help would be appreciated! Thanks, Greg
		Add comment


Seyfullah IZMIRLI 13 October 2008 09:37:07 [ permanent link ]
	If i were you, i'll use DateTime as Float... for example. SELECT <NEEDED FIELDS> FROM <TABLE> WHERE <FILTEREDDATE> > CAST(39732,39990 AS DATETIME) with this case i would use the limitation as seconds Have fun with SQL Seyfullah IZMIRLI "Greg" <greg@redseahookah.com>, haber iletisinde sunlari yazdi:A7F9400E-81D7-443E-A9B7-DE0F354FDF50@microsoft.com... I've built a Point-of-Sale using "classic" asp (it's what I know) and I'm trying to get daily sales totals. The problem is sales for the day do not stop at 11:59pm. What is a clean way to select the records from say 8:00am at start of business to 4:00am the next morning? I should be able to figure this out, but I think I've been looking at this too long... Any help would be appreciated! Thanks, Greg
		Add comment

QAIX > ASP web-programming > Select Records between Date/Time & Date/Time? 13 October 2008 09:37:07

	see also: [Security & JAAS/JBoss] - Re: How can I… [Installation, Configuration &… [EJB 3.0] - Re: Database overwritten at…		пройди тесты:		see also: avast! Virus Cleaner world's first 10 megapixel multimedia… Firefox Users to Advise Mozilla

Copyright © 2001—2008 QAIX
Idea: Miсhael Monashev
Помощь и задать вопросы можно в сообществе support.qaix.com.
Сообщения об ошибках оставляем в сообществе bugs.qaix.com.
Предложения и комментарии пишем в сообществе suggest.qaix.com.
Информация для родителей.
Write us at:

If you would like to report an abuse of our service, such as a spam message, please .




Get comments by e-mail Add to favourites

Пожалуйста, относитесь к собеседникам уважительно, не используйте нецензурные слова, не злоупотребляйте заглавными буквами, не публикуйте рекламу и объявления о купле/продаже, а также материалы нарушающие сетевой этикет или УК РФ.

Select Records between Date/Time & Date/Time?

Add new comment