English Date Required

hg363 — Wed, 17 Jun 2009 21:58:27 GMT

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)

Input Formats

English Date Required