Query Time Stamp

[Anon]

Here is the table

date name

timestamp(14) text

20001020173304 Joe
20001021014916 Bill
20001021021011 Willy
20000122000000 John
20000122000000 Chris
20000122000000 Howard

**********Question************
I want to query all of the users who registered within the current week

sunday to sunday

I think it is something like this

SELECT name
FROM table
WHERE date between "$var" "var"

How do you do this?

[djurnoce]

I would do it like this:

SELECT name
FROM table
WHERE date>=\"$startdate\"
AND date<=\"$enddate\"
ORDER BY date;