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

In reply to Re^2: Converting dates by denzil_cactus
in thread Converting dates by denzil_cactus

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.