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|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|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|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|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|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|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|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|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>

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>.

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

数据库

MySQL

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

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

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

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

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

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