Current location: Hot Scripts Forums » Programming Languages » ASP » Selecting records by date


Selecting records by date

Reply
  #1 (permalink)  
Old 02-23-06, 08:46 AM
huragano huragano is offline
Newbie Coder
 
Join Date: Feb 2006
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Selecting records by date

Hello !
My question is simple. I have a db where each recordset has a date entry (that's the day it was posted).
Now I need to display only entries posted from a certain day to another day (ex. only the entries posted from the 4th of Januery till the 6th of february).

Anyone can tell me how the "SELECT * FROM" line should look like ?!?
Thanks a lot.
Reply With Quote
  #2 (permalink)  
Old 02-24-06, 12:35 PM
koncept
Guest
 
Posts: n/a
select * from table where date between date1 and date2
http://www.w3schools.com/sql/sql_between.asp
Reply With Quote
Reply

Bookmarks


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
[SOLVED] Selecting the Last 50 Records of MySQL db v1brazy Database 7 04-15-09 03:40 PM
js date franches JavaScript 1 11-25-04 08:42 AM
search form with date search newbieasp24 ASP 1 10-17-04 02:52 PM
Problem with date and form djavet PHP 3 05-02-04 12:37 AM
help! urgent.. how to select next 50 records? angela ASP 3 04-24-04 12:58 PM


All times are GMT -5. The time now is 03:41 PM.
vBulletin® Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.