Re: Change Date format in ISA logfiles
- From: "Chris Leonard" <chris@xxxxxxxxxxxxxxx>
- To: "[ISAserver.org Discussion List]" <isalist@xxxxxxxxxxxxx>
- Date: Thu, 31 Jan 2002 08:55:12 -0600
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:
