now() integer format

[abertay]

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(I dont want this format).
It's weird and i can't understand what the problem.

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

[mwasif]

Use DATE_FORMAT() to view the required date format.