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.