[SOLVED] php time function

[kev wood]

i am trying to store the time inside a mysql db at the moment i am tying to store this using the NOW() function which i was under the impression that this would store the date and the time inside the db but all i keep getting stored inside is 2008.

 

should this function give just the year or should it give the time and date also.

[homer.favenir]

now() function returns yyyy-mm-dd hh:mm:ss

[GingerRobot]

I would imagine the field type you're trying to insert into is incorrect. Try changing it to a DATETIME field.

[Darklink]

You have it at INTEGER I think. Change it to VARCHAR(20). Should do the trick.

[Zane]

you need to show us your code and how you are inserting the time.

 

then all the questions of UNIX timestamps and NOW() functions that'll come up later won't be as confusing.

 

 

but before I decide to tell you about using a UNIX timestamp instead of the NOW() function....we all need to see you current code so you don't mess it up with random lines people are probably going to give you.

[kev wood]

just to show you that the NOW() function is not working as it should here is a screen shot of what was in the db after the ode had been run.

 

www.acmeart.co.uk/test/screenshot.jpg

 

i will try changing it to a varchar (20) and see what that produces

[kev wood]

it is working now thank you for the replies on this again some of you.  and thank the rest of you for your new input.