MySQL Forums
Forum List  »  Portuguese

Re: Mysql Excel com FROM_UNIXTIME(TIMESTAMP)
Posted by: Marcos Carmello
Date: August 19, 2008 11:11AM

Well, descobri a diferença:

- para windows 2k eu utilizo a função FROM_UNIXTIME(date_created,'%d=%m-%Y') para "converter" a formatação;
- para linux basta utilizar FROM_UNIXTIME(date_created) para vir convertido (d-m-y H:m:s).

Basta formatar a coluna no Excel para formatar apenas data.

Desculpem a "Noobice", até +!

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Mysql Excel com FROM_UNIXTIME(TIMESTAMP)
5521
August 19, 2008 11:11AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.