Five Stars

How to convert of epoch time to human readable format

I have epoch time in my file. It may normal or in miliseconds. Please tell how to convert these epoch times in normal human readable format.

 

Epoch time examples:

1) Normal               1492430625             Indian Local time   nearly same as below time

2)In miliseconds     1492430501465       Indian Local time Mon Apr 17 2017 17:31:41

  • Data Integration
Tags (1)
1 ACCEPTED SOLUTION

Accepted Solutions
Eleven Stars

Re: How to convert of epoch time to human readable format

You will need to know which value you are working with. The code I am giving you will work with time in milliseconds. In order to convert the other time unit you described, just multiply it by 1000.

 

Long myTimeAsLong = 1492430501465L;
SimpleDateFormat sdf = new SimpleDateFormat("dd/MM/yyyy");
System.out.println(sdf.format(new Date(myTimeAsLong)));

 ...or if you wanted to create a routine for this, you could use the following static function...

    public static String getDateFromEpoch(Long timeAsLong, String javaDatePattern){
        
    	String returnVal = null;
    	
    	if(timeAsLong!=null){
        	SimpleDateFormat sdf = new SimpleDateFormat(javaDatePattern);
        	returnVal = sdf.format(new Date(timeAsLong)); 	
        }
    	return returnVal;
    }
Rilhia Solutions
2 REPLIES
Eleven Stars

Re: How to convert of epoch time to human readable format

You will need to know which value you are working with. The code I am giving you will work with time in milliseconds. In order to convert the other time unit you described, just multiply it by 1000.

 

Long myTimeAsLong = 1492430501465L;
SimpleDateFormat sdf = new SimpleDateFormat("dd/MM/yyyy");
System.out.println(sdf.format(new Date(myTimeAsLong)));

 ...or if you wanted to create a routine for this, you could use the following static function...

    public static String getDateFromEpoch(Long timeAsLong, String javaDatePattern){
        
    	String returnVal = null;
    	
    	if(timeAsLong!=null){
        	SimpleDateFormat sdf = new SimpleDateFormat(javaDatePattern);
        	returnVal = sdf.format(new Date(timeAsLong)); 	
        }
    	return returnVal;
    }
Rilhia Solutions
Five Stars

Re: How to convert of epoch time to human readable format

Thanks for this solution.. I have used below mentioned function directly in tMap worked fine for me....

(row1.epochtime == null || row1.epochtime =="") ? null : (new java.util.Date(Long.parseLong(row1.epochtime) * 1000) );



Where row1.epochtime has string of epoch time in seconds ...


Function returns time in "date" format