List:General Discussion« Previous MessageNext Message »
From:Ashley M. Kirchner Date:May 17 2004 6:47am
Subject:Select on datetime
View as plain text  
    I have a table that has a datetime field that gets set every time 
data gets entered in the table (for example "2004-05-16 19:08:59").  How 
can I select all entries that were entered one year ago today.  And, how 
can I select entries that were entered one year ago today +7 days.

    So, if today being 2004-05-16,
    -> I want to select all entries dated 2003-05-16
    -> And I also want entries dated between 2003-05-16 and 2003-05-23

-- 
 H| I haven't lost my mind; it's backed up on tape somewhere.
  +--------------------------------------------------------------------
  Ashley M. Kirchner <mailto:ashley@stripped>   .   303.442.6410 x130
  IT Director / SysAdmin / WebSmith             .     800.441.3873 x130
  Photo Craft Laboratories, Inc.            .     3550 Arapahoe Ave. #6
  http://www.pcraft.com ..... .  .    .       Boulder, CO 80303, U.S.A. 



Thread
Select on datetimeAshley M. Kirchner17 May
  • Re: Select on datetimeRoger Baklund17 May