Thanks it works but now the problem is

use POSIX qw(strftime);



$str = "1164414128";

print strftime '%Y-%m-%d %h:%m:%S', gmtime($str);
[download]

I am getting the print 2006-11-25 00:22:08 but when I queried from the database it was

SELECT ini_Rate.tUpdate from ini_Rate where ini_Rate.tUpdate > ini_Rat
+e.tEnter limit 1;
+---------------------+
| tUpdate             |
+---------------------+
| 2006-11-25 05:52:08 |
+---------------------+


SELECT unix_timestamp(ini_Rate.tUpdate) from ini_Rate where ini_Rate.t
+Update > ini_Rate.tEnter limit 1;
+-----------------------------------------+
| unix_timestamp(ini_Rate.tUpdate)        |
+-----------------------------------------+
|                              1164414128 |
+-----------------------------------------+
[download]

So I need to get 2006-11-25 05:52:08 but its printing 2006-11-25 00:22:08 suggest me