28-Jul-2006, 08:38 AM
|  | Guest | | | | | | | | | | Re: earliest and latest date/time per day
select min(a.timestamp), max(a.timestamp) From mytable ?
Pieter wrote in message
news:4pkvb2t4b87dlvsd5r6ak54cgmrnht2sr0@4ax.com...
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13642
>I have some data that is date/time.
> I need to be able to pick out the earliest time stamp and the latest
> time stamp for a particular date(s). What would be the query to have a
> report show only those two date/time criteria yet not show all the
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13642
> other time stamps in between?
> access 2000 on xp.
> thank you.
|
28-Jul-2006, 08:38 AM
| | Guest | | | | | | | | | | Re: earliest and latest date/time per day
select min(a.timestamp), max(a.timestamp) From mytable ?
Pieter wrote in message
news:4pkvb2t4b87dlvsd5r6ak54cgmrnht2sr0@4ax.com...
>I have some data that is date/time.
> I need to be able to pick out the earliest time stamp and the latest
> time stamp for a particular date(s). What would be the query to have a
> report show only those two date/time criteria yet not show all the
> other time stamps in between?
> access 2000 on xp.
> thank you.
--
----------------------------------------
I am using the free version of SPAMfighter for private users.
It has removed 4285 spam emails to date.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13642
Paying users do not have this message in their emails.
Get the free SPAMfighter here: http://www.spamfighter.com/len
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13642
| 
Support Us! Become a Promoter! | | Gurfateh ji, you can become a SPN Promoter by Donating as little as $10 each month. With limited resources & high operational costs, your donations make it possible for us to deliver a quality website and spread the teachings of the Sri Guru Granth Sahib Ji, to serve & uplift humanity. Every contribution counts. Donate Generously. Gurfateh! |
 (View-All)
Members who have read this thread : 0
| | There are no names to display. |
|
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | | | | Tools | Search | | | | | Display Modes |  Linear Mode |
Posting Rules
| You may not post new threads You may not post replies You may not post attachments You may not edit your posts
HTML code is On
| | | |  | » Gurbani Jukebox |  Listen to Gurbani while surfing SPN! | | » Active Discussions | | | | | | |  ਨਾਮਾ Today 06:37 AM 2 Replies, 53 Views | | | | | | | | | | | | | | | | | | | | | | | | » Books You Should Read... | | | |
All times are GMT +6.5. The time now is
09:37 AM.
Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Search Engine Optimization by
vBSEO 3.5.2
Copyright © 2004-12, All Rights Reserved. Sikh Philosophy Network
