Re: Change Date format in ISA logfiles

You may want to try logging to an ODBC data source, and then using that
database's query language to reformat the date when retrieving the data.
Below I'm listing a couple of queries that demonstrate converting a date to
the format you want, using Oracle or SQL Server.  I'm just using arbitrary
date and column names, of course.

Oracle example:
select to_char(date_column, 'MM/DD/YYYY') from logging_table;

Microsoft SQL Server example:
select convert(varchar, date_column, 101)  from logging_table

Hope this helps!
Chris
______________________________
Chris Leonard
MCSE, MCDBA, MCT, OCP, CIW
The Database Guy at PPI
http://www.propoint.com
Brainbench MVP for Oracle Admin
http://www.brainbench.com



----- Original Message -----
From: "AJB" <isaserver@xxxxxxxxxxxxxxxx>
To: "[ISAserver.org Discussion List]" <isalist@xxxxxxxxxxxxx>
Sent: Wednesday, January 30, 2002 05:45
Subject: [isalist] Change Date format in ISA logfiles


http://www.ISAserver.org


Hi,

For reporting I need to change the date format in ISA  logfiles.
Now it is: 1/30/2002 or 2/1/2002 What I want is:  01/30/2002 or
02/01/2002
Thank for your help,

Other related posts: