Hot answers tagged logging
1
Try the -x option for bash:
bash -x "PERL5LIB=${PERL5LIB}:/something/extra my-command.pl many arguments which I want to save" 2>&1 | tee -a my-command.log
My test:
$ bash -x -c "echo a bunch of difffernt arguments"
+ echo a bunch of difffernt arguments
a bunch of difffernt arguments
1
Triggers have all of the drawbacks you describe. Specifically, if the database intended to receive the logs happens to be down, not only do you lose logging, but any query which would generate a log entry will fail unless the trigger is carefully written to avoid this. Using a periodic job to copy the log data across to the receiving database doesn't have ...
1
IF time is not critical to your calculation, you can use this formula to convert the text to a date:
Assuming your value is in A1, then
=DATE(MID(A1,9,4),MONTH("1 "&(MID(A1,5,3))),MID(A1,2,2))
This will return an Excel aware 04/02/13 (based on regional date settings.
Only top voted, non community-wiki answers of a minimum length are eligible
