consulta unix timestamp

[huesos52]

Tenes razón... hay un problema de casteos.

Prueba esta:

Código SQL:

WHERE
FROM_UNIXTIME(lastaccess)
BETWEEN
DATE_SUB(FROM_UNIXTIME(UNIX_TIMESTAMP()), INTERVAL 1 WEEK)
AND
FROM_UNIXTIME(UNIX_TIMESTAMP());