Article View: pl.comp.bazy-danych
Article #194983mySQL - kolumna TIMESTAMP
From: Borneq
Date: Fri, 10 Jun 2016 08:55
Date: Fri, 10 Jun 2016 08:55
4 lines
1012 bytes
1012 bytes
Mam czas w formacie Unixa - sekundy od 1970 roku. Jak wpisywać to w insert/update? Jak w mySQL podawać czas? Czy "2016-06-10 10:51:33", czy zawsze tak samo, najpierw roku itd?
Technical Details
Message-ID:
<njdvap$2uv$1@node1.news.atman.pl>Path:
mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!agh.edu.pl!news.agh.edu.pl!newsfeed2.atman.pl!newsfeed.atman.pl!.POSTED!not-for-mailShow Full Headers
Complete Article Headers
Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!agh.edu.pl!news.agh.edu.pl!newsfeed2.atman.pl!newsfeed.atman.pl!.POSTED!not-for-mail From: Borneq <borneq@antyspam.hidden.pl> Newsgroups: pl.comp.bazy-danych Subject: mySQL - kolumna TIMESTAMP Date: Fri, 10 Jun 2016 10:55:53 +0200 Organization: ATMAN - ATM S.A. Lines: 4 Message-ID: <njdvap$2uv$1@node1.news.atman.pl> NNTP-Posting-Host: apn-77-115-96-235.dynamic.gprs.plus.pl Mime-Version: 1.0 X-Trace: node1.news.atman.pl 1465548953 3039 77.115.96.235 (10 Jun 2016 08:55:53 GMT) X-Complaints-To: usenet@atman.pl NNTP-Posting-Date: Fri, 10 Jun 2016 08:55:53 +0000 (UTC) User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:45.0) Gecko/20100101 Thunderbird/45.1.1 X-Mozilla-News-Host: news://news.atman.pl:119 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit