Søge 1 time tilbage ud fra et givent tidspunkt dato?

Prøv med:
MSSQL_QUERY("SELECT id, date, severity, facility, source, message FROM Syslog WHERE date = DATEADD(hh, -1, convert(datetime,'????????'))");

Nej forresten: Der skal lidt mere til. Du kan benytte funktion BETWEEN.

Så det ser således ud:
MSSQL_QUERY("SELECT id, date, severity, facility, source, message FROM Syslog WHERE date BETWEEN DATEADD(hh, -1, convert(datetime,'????????')) AND  convert(datetime,'????????')");

Kan jeg sætte ???????? = timenow?

Brug: getDate()

Det giver dig dato og tiden her og nu.

Sådan her?

$getDate=getDate();

MSSQL_QUERY("SELECT id, date, severity, facility, source, message FROM Syslog WHERE date BETWEEN DATEADD(hh, -1, convert(datetime,'$getDate')) AND  convert(datetime,'$getDate')");

Eller blot:

MSSQL_QUERY("SELECT id, date, severity, facility, source, message FROM Syslog WHERE date BETWEEN DATEADD(hh, -1, GETDATE()) AND GETDATE()");