[RESOLVED] Registered Date & Last Login Date

ljcasey

Hi I have a Registered Date & Last Login Date field in one of my tables. Ive done some research and (kinda) understand that mysql uses one format and php uses another...

First of all, whats the best way to store the date? ie. int(11)? or is it easier to use TIMESTAMP(14)?

bogu

TIMESTAMP is best and INT is not wrong either...

ljcasey

I will post what i did as it this subject seems to raise alot of confusion.

in my database i used int(11)

then i inserted the php function time() into it. which is a timestamp.

Then when i retrieved the timestamp i used date('l dS \of F Y h:i:s A', <time() from db here>); to present it in the format i required. you can find different formats in the php manual.

bogu

Well u know that timestamp is the time represented as an integer, thats why I said that int is not wrong, but maybe it will be to short in the future so in mysql there is the timestamp(14) wich is a bigger value and is special made for storing the time value ...

ljcasey

bogu wrote:
Well u know that timestamp is the time represented as an integer, thats why I said that int is not wrong, but maybe it will be to short in the future so in mysql there is the timestamp(14) wich is a bigger value and is special made for storing the time value ...

So is it possible to create a mysql timestamp within php? MYSQL_TIMESTAMP() maybe? and is it possible to use that time stamp in date(format, timestamp)?

bogu

timestamp is a standard format in php u have mktime() and in mysql u have UNIX_TIMESTAMP() ...