Can someone advise on the statement to get the date part of a timestamp:
Field1: 20.081.006.122.243
I would like just the date part, to be displayed ideally as 06102008 otherwise as 20081006
Thanks