Hi Barry, you are right, MySQL is using milliseconds from 1/1/1970.
And my apologies again, in AUS time 1231200312179 translates to
6/1/2009 11:05:12 (I had american time in the previous post).
I tried Dan's way with using dhms('01jan1970'd,0,0,timeStamp/1000)and
format of dateTime. the dates are showing now, however it seems 'off'
by 11 hours. for example: 1231203455893 should be translated to
6/1/2009 11:57:35. Instead I get 6/1/2009 00:57:35.
Getting close... on another note, what exactly does dhms() function
do? Sorry a bit new with SAS.