MYSQL DB timestamp not saving records. rather saves in datetime format

Question

i have a column that is a timestamp to store a date time. so i am inputting the time() result to save the value in to that column in database.

for example, result generated by time() = 1385714063 // a timestamp

echo time() //1385714063

I am adding 1385714063 (timestamp) and saving but it automatically converts 1385714063 in to 2013-11-14 00:00:00 which i dont understand how.

why i am not allowed to store the value as a timestamp(1385714063) or why is it doing the conversion is my question.

UPDATE 1

I tried, NOW() as explained in the first answer but it doesnt help me

Mahmood Rehman · Accepted Answer · 2013-11-29 09:25:20Z

2

Try echo date("Y-m-d H:i:s"); method to store date time .My sql Database uses formate.now() is mysql function not php

edited Nov 29, 2013 at 9:25

answered Nov 29, 2013 at 9:17

Mahmood Rehman

4,3377 gold badges43 silver badges76 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

dev1234 Over a year ago

it says, Call to undefined function now()

Mahmood Rehman Over a year ago

Sorry check answer now

Asim Muhammad · Accepted Answer · 2013-11-29 09:26:52Z

1

Use this

SELECT UNIX_TIMESTAMP(NOW())

But i think TIMESTAMP datatype will store in "YYYY-mm-dd h:i:s" so for the timestamp you want you can use other datatype like bigint or varchar

answered Nov 29, 2013 at 9:26

Asim Muhammad

413 bronze badges

Comments

Alexander · Accepted Answer · 2013-11-29 09:37:05Z

1

Datatype timestamp in MySQL is stored internally value as four-byte integer value, but externally, you need to work with this datatype as with string. If you want to store timestamp value as integer value in MySQL, then use datatype INT.

answered Nov 29, 2013 at 9:37

Alexander

8095 silver badges10 bronze badges

Comments

Rob · Accepted Answer · 2013-11-29 09:26:30Z

0

The TIMESTAMP data type is used for values that contain both date and time parts. TIMESTAMP has a range of '1970-01-01 00:00:01' UTC to '2038-01-19 03:14:07' UTC.

https://dev.mysql.com/doc/refman/5.5/en/datetime.html

You should insert your date in the format of Y-m-d H:i:s

answered Nov 29, 2013 at 9:26

Rob

12.9k4 gold badges44 silver badges57 bronze badges

Collectives™ on Stack Overflow

MYSQL DB timestamp not saving records. rather saves in datetime format

4 Answers 4

2 Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related