blocks|key|718454|text|像这样传过去|type|unstyled|depth|inlineStyleRanges|entityRanges|data|718455|date('Y-m-d+H:i:s','1299762201428')|code-block|syntax|javascript|718456|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

pass like this

<pre><code>date('Y-m-d H:i:s','1299762201428')
</code></pre>

blocks|key|934244|text|嘿，对此使用FROM_UNIXTIME()函数。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|934245|如下所示：|934246|INSERT+INTO+table_name
(id,d_id,l_id,connection,s_time,upload_items_count,download_items_count,t_time,status)
VALUES
(1,5,9,'2',FROM_UNIXTIME(1299762201428),5,10,20,'1'),+
(2,5,9,'2',FROM_UNIXTIME(1299762201428),5,10,20,'1')|code-block|syntax|javascript|934247|entityMap^0|6|F|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@$9|P|A|Q|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|R|8|@]|D|@]|E|$]]|$1|H|3|I|5|J|7|S|8|@]|D|@]|E|$K|L]]|$1|M|3|-4|5|6|7|T|8|@]|D|@]|E|$]]]|N|$]]

Hey there, use the <code>FROM_UNIXTIME()</code> function for this.

Like this:

<pre><code>INSERT INTO table_name
(id,d_id,l_id,connection,s_time,upload_items_count,download_items_count,t_time,status)
VALUES
(1,5,9,'2',FROM_UNIXTIME(1299762201428),5,10,20,'1'), 
(2,5,9,'2',FROM_UNIXTIME(1299762201428),5,10,20,'1')
</code></pre>

blocks|key|718749|text|$created_date+=+date("Y-m-d+H:i:s");
$sql+=+"INSERT+INTO+$tbl_name(created_date)VALUES('$created_date')";
$result+=+mysql_query($sql);|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|718750|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>$created_date = date("Y-m-d H:i:s");
$sql = "INSERT INTO $tbl_name(created_date)VALUES('$created_date')";
$result = mysql_query($sql);
</code></pre>

blocks|key|718744|text|您也可以在查询中使用now()，例如：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|718745|insert+into+table+(time)+values(now());|code-block|syntax|javascript|718746|它将使用当前的时间戳。|718747|entityMap^0|A|5|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@$9|P|A|Q|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|R|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|S|8|@]|D|@]|E|$]]|$1|M|3|-4|5|6|7|T|8|@]|D|@]|E|$]]]|N|$]]

You can use <code>now()</code> as well in your query, i.e. :

<pre class="lang-sql prettyprint-override"><code>insert into table (time) values(now());
</code></pre>

It will use the current timestamp.

blocks|key|718593|text|使用FROM_UNIXTIME()。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|718594|注意:+1299762201428看起来更像是毫秒时间戳(如JavaScript中的Date()*1+)，您可能需要将其除以1000。|718595|entityMap|0|LINK|mutability|MUTABLE|url|http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_from-unixtime^0|2|F|2|F|0|0|0^^$0|@$1|2|3|4|5|6|7|P|8|@$9|Q|A|R|B|C]]|D|@$9|S|A|T|1|U]]|E|$]]|$1|F|3|G|5|6|7|V|8|@]|D|@]|E|$]]|$1|H|3|-4|5|6|7|W|8|@]|D|@]|E|$]]]|I|$J|$5|K|L|M|E|$N|O]]]]

Use <a href="http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_from-unixtime" rel="nofollow"><code>FROM_UNIXTIME()</code></a>.

Note: 1299762201428 looks more like a millisecond-timestamp (like Date()*1 in JavaScript), and you probably have to divide that by 1000.

blocks|key|934383|text|检查表格中的字段类型，只需将时间戳值保存为bigint等数据类型即可。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|934384|非datetime类型|934385|entityMap^0|L|6|0|1|8|0^^$0|@$1|2|3|4|5|6|7|J|8|@$9|K|A|L|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|M|8|@$9|N|A|O|B|C]]|D|@]|E|$]]|$1|H|3|-4|5|6|7|P|8|@]|D|@]|E|$]]]|I|$]]

Check field type in table just save time stamp value in datatype like <code>bigint</code> etc.

Not <code>datetime</code> type

blocks|key|934387|text|这应该可以做到：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|934388|++$time+=+new+DateTime;+|code-block|syntax|javascript|934389|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

This should do it:

<pre><code> $time = new DateTime; 
</code></pre>

blocks|key|718512|text|如果时间戳是当前时间，则可以使用mysql+NOW()函数|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|718513|entityMap^0|M|5|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|K|8|@]|D|@]|E|$]]]|G|$]]

If the timestamp is the current time, you could use the mysql <code>NOW()</code> function

blocks|key|718634|text|使用datetime字段类型。它有很多优点，比如人类的可读性(没有人会阅读时间戳)和MySQL+functions。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|718635|要从unix时间戳进行转换，可以使用MySQL函数FROM_UNIXTIME(1299762201428)。要转换回来，可以使用UNIX_TIMESTAMP：SELECT+UNIX_TIMESTAMP(t_time)+FROM+table_name。|718636|当然，如果你不喜欢MySQL函数，你可以使用PHP：'INSERT+INTO+table_name+SET+t_time+=+'+.+date('Y-m-d+H:i:s',+$unix_timestamp)。|718637|entityMap|0|LINK|mutability|MUTABLE|url|http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html^0|2|8|16|F|0|0|P|S|1S|E|27|19|0|Q|25|0^^$0|@$1|2|3|4|5|6|7|R|8|@$9|S|A|T|B|C]]|D|@$9|U|A|V|1|W]]|E|$]]|$1|F|3|G|5|6|7|X|8|@$9|Y|A|Z|B|C]|$9|10|A|11|B|C]|$9|12|A|13|B|C]]|D|@]|E|$]]|$1|H|3|I|5|6|7|14|8|@$9|15|A|16|B|C]]|D|@]|E|$]]|$1|J|3|-4|5|6|7|17|8|@]|D|@]|E|$]]]|K|$L|$5|M|N|O|E|$P|Q]]]]

Use <code>datetime</code> field type. It comes with many advantages like human readability (nobody reads timestamps) and <a href="http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html" rel="nofollow">MySQL functions</a>.

To convert from a unix timestamp, you can use MySQL function <code>FROM_UNIXTIME(1299762201428)</code>. To convert back you can use <code>UNIX_TIMESTAMP</code>: <code>SELECT UNIX_TIMESTAMP(t_time) FROM table_name</code>.

Of course, if you don't like MySQL function, you could always use PHP: <code>'INSERT INTO table_name SET t_time = ' . date('Y-m-d H:i:s', $unix_timestamp)</code>.

blocks|key|934347|text|最好使用数据类型varchar(15)。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|934348|entityMap^0|8|B|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|K|8|@]|D|@]|E|$]]]|G|$]]

Better is use datatype <code>varchar(15)</code>.

blocks|key|934491|text|你可以这样做：$date+=+\gmdate(\DATE_ISO8601);。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|934492|entityMap^0|7|V|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|K|8|@]|D|@]|E|$]]]|G|$]]

You can do: <code>$date = \gmdate(\DATE_ISO8601);</code>.

blocks|key|718793|text|如果我知道数据库是MySQL，我会像这样使用NOW()函数：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|718794|INSERT+INTO+table_name
+++(id,+name,+created_at)+
VALUES+
+++(1,+'Gordon',+NOW())+|code-block|syntax|javascript|718795|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

If I know the database is MySQL, I'll use the NOW() function like this:

<pre><code>INSERT INTO table_name
 (id, name, created_at) 
VALUES 
 (1, 'Gordon', NOW()) 
</code></pre>

I have a field in a MySQL table which has a <code>timestamp</code> data type. I am saving data into that table. But when I pass the timestamp (<code>1299762201428</code>) to the record, it automatically saves the value <code>0000-00-00 00:00:00</code> into that table.

How can I store the timestamp in a MySQL table?

Here is my <code>INSERT</code> statement:

<pre><code>INSERT INTO table_name (id,d_id,l_id,connection,s_time,upload_items_count,download_items_count,t_time,status)
VALUES (1,5,9,'2',1299762201428,5,10,20,'1'),
 (2,5,9,'2',1299762201428,5,10,20,'1')
</code></pre>

Saving timestamp in mysql table using php

我在一个数据类型为timestamp的MySQL表中有一个字段。我正在将数据保存到该表中。但是当我将时间戳(1299762201428)传递给记录时，它会自动将值0000-00-00 00:00:00保存到该表中。如何将时间戳存储在MySQL表中？下面是我的INSERT语句：INSERT INTO table_name (id,d_id,l_id,connection,s_time,upload_

问用php在mysql表中保存时间戳
EN

回答 12

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问用php在mysql表中保存时间戳EN

回答 12

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问用php在mysql表中保存时间戳
EN