Saving timestamp in mysql table using php

Question

I have a field in a MySQL table which has a timestamp data type  I am saving data into that table  But when I pass the timestamp  1299762201428  to the record  it automatically saves the value 0000-00-00 00 00 00 into that table   How can I store the timestamp in a MySQL table   Here is my INSERT statement   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

User · Answer

Some things to clarify    MySQL timestamp field type doesn t store unix timestamps but rather a datetime-kind value  UNIX timestamp is a number of a regular int type  The timestamp you re talking about is not a regular unix timestamp but a timestamp with milliseconds     therefore the correct answer would be    timestamp    1299762201428    date   date  Y-m-d H i s   substr  timestamp  0  -3

User · Answer

If I know the database is MySQL  I ll use the NOW   function like this   INSERT INTO table name     id  name  created at   VALUES      1   Gordon   NOW

User · Answer

Datatype  bigint unsigned  may suit this requirement

User · Answer

pass like this  date  Y-m-d H i s   1299762201428

User · Answer

created date   date  Y-m-d H i s     sql    INSERT INTO  tbl name created date VALUES   created date      result   mysql query  sql

User · Answer

Check field type in table just save time stamp value in datatype like  bigint etc   Not datetime type

User · Answer

Hey there  use the FROM UNIXTIME   function for this   Like this   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

User · Answer

If the timestamp is the current time  you could use the mysql NOW   function

User · Answer

Better is use datatype varchar 15

User · Answer

Use FROM UNIXTIME     Note  1299762201428 looks more like a millisecond-timestamp  like Date   1 in JavaScript   and you probably have to divide that by 1000

User · Answer

Use datetime field type  It comes with many advantages like human readability  nobody reads timestamps  and MySQL functions   To convert from a unix timestamp  you can use MySQL function FROM UNIXTIME 1299762201428   To convert back you can use UNIX TIMESTAMP  SELECT UNIX TIMESTAMP t time  FROM table name   Of course  if you don t like MySQL function  you could always use PHP   INSERT INTO table name SET t time       date  Y-m-d H i s    unix timestamp

User · Answer

This should do it      time   new DateTime

User · Answer

I m guessing that the field you are trying to save the value in is a datetime field it s not but the same seems to be true for timestamps  If so mysql expects the format to be Year-month-day Hour minute second  In order to save the timestamp you will have to convert the field to numeric using a query like  alter table  lt table name gt  change  lt field gt   lt field gt  bigint unsigned   If you are using the current time you can use now   or current timestamp

User · Answer

You can do   date    gmdate  DATE ISO8601

User · Answer

You can use now   as well in your query  i e     insert into table  time  values now       It will use the current timestamp

[php] Saving timestamp in mysql table using php

Examples related to php

Examples related to mysql

Examples related to database

Examples related to sql-insert