PHP Date Function

Question

I'm trying to store the current date and time in a MySQL database, but when storing it stores in a different format:

I'm using date("Y-m-d H:i:s");
But it's stored as 20/16/1017
It should be 2016-10-17 15:23:23

View

$date = date("Y-m-d H:i:s");
<input type="hidden"  name="date" id="date" value="<?php echo $date; ?>">

Model

function InsertAdd($data)
    {
        $this->db->insert('advertisements', $data);
    }

Controller

$data = array(

                    'Date' => $this->input->post('date'),

                );

Note: - i have changed my type to datetime and default is currenttime in mysql db

SO maybe if you shared the code that actually does the storing to the database we could do something **other than guess** — RiggsFolly, Oct 17 '16 at 09:47
It would also be useful to know the DataType of the Column you are storing this date value into!!! — RiggsFolly, Oct 17 '16 at 09:48
@RiggsFolly: dataType is Varchar i guess because value is `20/16/1017` maybe — devpro, Oct 17 '16 at 09:49
@devpro Maybe! but that would not explain how the format got scrambled. My **guess** is OP is not actually storing `$data` but something else — RiggsFolly, Oct 17 '16 at 09:51
@RiggsFolly yes its varchar(255).what i am doing here is simply submitting a form.im passing date as hidden value. — colombo, Oct 17 '16 at 09:51
**Dont store datetime in VARCHAR columns**. Store them in DATETIME or TIMESTAMP datatypes — RiggsFolly, Oct 17 '16 at 09:52
@colombo: Try changing your date field to this: `date TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP` — Abdush Shakoor Mohamed Nazeer, Oct 17 '16 at 09:54
@RiggsFolly i change it to DATETIME. but now it prints 0000-00-00 00:00:00 — colombo, Oct 17 '16 at 09:54
@colombo Have you already tried storing the timestamp (`time()`) in a `int(11)` field? — Sainan, Oct 17 '16 at 09:55
**Show us** the PHP code that you use to store this value to the database **Edit** your question, dont paste code in a comment — RiggsFolly, Oct 17 '16 at 09:57
Hope this help.. http://stackoverflow.com/questions/17077071/date-is-inserting-as-0000-00-00-000000-in-mysql — mamun0024, Oct 17 '16 at 10:01
dont know why are u using `$date = date("Y-m-d H:i:s");` you can use TimeStamp data type and and Default value as CURRENT_TIMESTAMP — devpro, Oct 17 '16 at 11:07

score -2 · Answer 1 · answered Oct 17 '16 at 09:54

-2

use strtotime to replace slash with - signs. Below should work:

  $date = date('Y-m-d h:i:s', strtotime(str_replace('/', '-', $date)));

answered Oct 17 '16 at 09:54

vaxzz

88
8

Couldn't you just short it down to `$date = str_replace("/", "-", $date);`? – Sainan Oct 17 '16 at 09:56
He appears to be using the current time, i.e. no second parameter. So this is irrelevant – RiggsFolly Oct 17 '16 at 09:56

PHP Date Function

1 Answers1