Hi this is a script from the Log Parser Toolkit book.
SELECT
quantize(TimeGenerated,3600) AS Time,
count(*) AS number_of_events
INTO netlog.gif
FROM \\h505050\system
WHERE SourceName like 'netlogon'
AND SUB(to_int(TimeGenerated), to_int(system_timestamp())) > -2592000
GROUP BY Time
And it works great. However the Date appears to be in US format, can some one kindly show me how to change the date to UK format, regards Mr Ghelani (UK)