My audit logs are stored in a database and the date/time format is as follows: Input (in Database) 9/16/2012 12:00:00 AM
I set the date time format for the field in Securonix as MM/dd/yyyy HH:mm:ss a However, I keep getting errors that the date/time format is incorrect. What am I doing wrong?
asked 01 Feb '13, 01:41
You need to specify the format in the SQL query itself if you want date/time to be retrieved in a specific format.
SELECT *, DATE_FORMAT(createdate, "%m-%d-%y") AS date FROM users;
This is the way you need to specify/format the date/time in the sql query and it should match the data/time format configured for the data/time fields/attributes.
answered 01 Feb '13, 01:44
You can also take a look at the temporary file that gets created in the import/in folder. This is generated prior to importing the data into Securonix.
answered 01 Feb '13, 01:45