Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.
Moderator: General Moderators
amir
Forum Contributor
Posts: 287 Joined: Sat Oct 07, 2006 4:28 pm
Post
by amir » Wed Nov 01, 2006 1:44 pm
ive got a slight issue where im facing to display all records that were added in the last 3 days from the current date.
our table contains a field called joined and i store a date value in it like:
so what date functions would i use to display all records in the last 3 days?
RobertGonzalez
Site Administrator
Posts: 14293 Joined: Tue Sep 09, 2003 6:04 pm
Location: Fremont, CA, USA
Post
by RobertGonzalez » Wed Nov 01, 2006 1:53 pm
Bear in mind that the newer (and more useful) date functions in MySQL are only available as of 4.1 (in some cases, 4.0, but almost none of the good ones are in 3.23).
amir
Forum Contributor
Posts: 287 Joined: Sat Oct 07, 2006 4:28 pm
Post
by amir » Wed Nov 01, 2006 2:05 pm
Thanks guys!
I got it working...