well... this example don't make sense for me...
And, this example never will work...
I don't know, maybe you looking for something like this :
Code:
Select logging_time as sDate,DBINFO('utc_to_datetime', logging_time) as sDateTime
From tempTable a
Where logging_time = (select b.logging_time from tempTable b where b.loggin_time = 134143242 )
There is no logic on this code, are just a syntax example....