Why does GB change the timestamp format?
Thank you to all those who have tried to solve this long outstanding issue. Why GB don't just add the preferred date format as an option in settings as they do with weight etc. However I have another problem with this. When I try the various methods to automatically extract the date the trunc() function works well for the first few entries then fails on others. Looking at the data I have the dates in varying formats, a "short" form and a "long" form. When I extracted all my logs from the start of this year I got the first few days as the "short" form and upon which the trunc() functions works fine. The data then changed from the 13th to the "long" form at which point the trunc() function doesn't work. Then back to the "short" form on the 1st Feb and continued with this until the 13thFeb where it changed back to the "long" form. I do see a pattern now of course where it changes on the 1st and the 13th of the month but why????
1/01/13 7:09
01/13/2013 09:14:00
2/01/13 6:01
02/13/2013 05:12:26
|