AnsweredAssumed Answered

Data Collection(last login date format) from CSV file

Question asked by shakti nayak on Jun 17, 2017
Latest reply on Jun 19, 2017 by Tim Willemstein

We are using a csv file to collect accounts and entitlements. We are using the csv type database Account collector to do that. The lastlogindates are in fomat of dd/mm/yyyy, but RSA IMG 6.9 needs mm/dd/yyyy format for last login dates.

 

Is there a mechanism to write a sql query to fetch the data in the correct format which is supported by RSA img 6.9.

We cannot change the date format in RSA IMG as there are other applications which use the mm/dd/yyyy format.

 

Does anybody know the function to change the data format in the sql query for database csv type colletor.

Outcomes