I am using the CLI Dataloader to successfully extract records from Salesforce as part of an interface into Back Office Systems. I have a query, a bit like this:
SELECT ID , ClosedDate, createdDate,date_resident__c FROM case WHERE status = 'Closed' AND RecordType.Name = 'SPD123' AND processed__c != TRUE
Unfortunately the Back Office Staff don't like the date formats of the created/closed date fields (timezone) or the custom date field (yyyy-mm-dd).
Is there a way I can extract the data using SOQL to reformat the timezone and date fields to the formats (DD/MM/YYYY hh:mm:ss for timezone and DD/MM/YYYY for date). I have tried some various SOQL functions but I know it doesn't support the full range normal SQL does.
If there isn't a way to do it in SOQL presumably the only way is batfile (I am already doing this for a few reasons so it isn't the end of the world).