now() displays incorrect time format

Junior WebHelper Joined: 19 Jul 2007 Posts: 1

I've inserted a record into mysql db using now() function value.

just like...

insert into TABLE_NAME(date,name,age)values(now(),'Naresh','24')

when tried to echo the date filed value on the local system,it gives me 2007-06-06 13:14:16.

But on the live system it gives me as 20070606131416.
It's weird and i can't understand what the problem.

And need to get the same format exactly as on the local system.
I need that format for my database queries.

can any one help me out here?

Thanks in advance.

Junior WebHelper Joined: 22 Oct 2009 Posts: 6

TABLE_NAME(date,name,age)values(date(),'Naresh','24').
This will solve your problem.

Posted: Fri Jul 10, 2015 3:19 pm (8 years, 9 months ago)

Hi All,

I am facing a issue in changing the date format of a column in my database. Below is my code

PHP Code: