Obrigada Nelson"" :)<br><br><b><i>Nelson Ferraz <nferraz@gmail.com></i></b> escreveu:<blockquote class="replbq" style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;"> Patty Silva wrote:<br>> Pessoal, extrai a data usando o MYSQL UNIX_TIMESTAMP(), como eu faco <br>> para visualizar qual data corresponde a essa saida<br>> ex: ele me gera assim: 1142996400 , quero vizualizar essa data no <br>> formato yyyy-mm-dd hh ;) tem como?<br><br>Procurando no Google:<br><br>http://www.google.com/search?q=mysql+unix_timestamp<br><br>Primeiro resultado:<br><br>FROM_UNIXTIME(unix_timestamp), FROM_UNIXTIME(unix_timestamp,format)<br><br>Returns a representation of the unix_timestamp argument as a value in <br>'YYYY-MM-DD HH:MM:SS' or YYYYMMDDHHMMSS format, depending on whether the <br>function is used in a string or numeric context. unix_timestamp is an <br>internal timestamp value such as is produced by the UNIX_TIMESTAMP()
<br>function.<br><br>If format is given, the result is formatted according to the format <br>string, which is used the same way as listed in the entry for the <br>DATE_FORMAT() function.<br><br>mysql> SELECT FROM_UNIXTIME(875996580);<br> -> '1997-10-04 22:23:00'<br>mysql> SELECT FROM_UNIXTIME(875996580) + 0;<br> -> 19971004222300<br>mysql> SELECT FROM_UNIXTIME(UNIX_TIMESTAMP(),<br> -> '%Y %D %M %h:%i:%s %x');<br> -> '2003 6th August 06:22:58 2003'<br><br>Note: If you use UNIX_TIMESTAMP() and FROM_UNIXTIME() to convert between <br>TIMESTAMP values and Unix timestamp values, the conversion is lossy <br>because the mapping is not one-to-one in both directions. For details, <br>see the description of the UNIX_TIMESTAMP() function.<br><br>http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html<br>_______________________________________________<br>Cascavel-pm mailing
list<br>Cascavel-pm@pm.org<br>http://mail.pm.org/mailman/listinfo/cascavel-pm<br></blockquote><br><p>
<hr size=1>
<a href="http://us.rd.yahoo.com/mail/br/tagline/mail/*http://br.info.mail.yahoo.com/">Abra sua conta no Yahoo! Mail</a> - 1GB de espaço, alertas de e-mail no celular e anti-spam realmente eficaz.