Date Problems

duckula

This is the pseudo code, I get a date from the user and convert it to Unix timestamp

$unix_DOB = UnixTimeFromDateString($POST['DOB_Day'],$POST['DOB_Month'],$POST['DOB_Year']);

This is the function UnixTimeFromDateString

function UnixTimeFromDateString($day,$month,$year) {

$unixtime = mktime(0,0,0,$month,$day,$year);
return $unixtime;

}

This is then stored in a mySQL database table.

When I retrieve the record I then do

$dayToSelect = date("d",$selectedUnixDate);
$monthToSelect = date("m",$selectedUnixDate);
$yearToSelect = date("Y",$selectedUnixDate);

This is performed this way because I am populating a list box and use the ToSelect variable to select that component in the list box.

The problem is that after doing the conversion back to day month year I do not get the same date that was entered, for example,

02/02/1990 gets stored as 633747600, when retrieved and reformatted it is now 31/01/1990.

Any ideas or assistance would be greatly appreciated.

bad76

Hi,
what kind of datetime is you mysql filed?

The problem may be that mysql datetime use Y-m-d order for sort enhancement...

see you

duckula

Storing the date as a timestamp so I don't have to be worried about date format being different on client to that of the server.

bad76

The first timestamp
field on db is autoupdated at every insert/update query.

Try to look for this...

duckula

Very confused now, the dateofbirth field was defined as bigint, which gave me the original problem. So, changed it to timestamp , and now cannot save the unixtime, so changed it back to bigint !!!

I have defined that field as bigint, is that correct ?

bad76

😕
I've recently work with timestamp and UNIX_TIMESTAMP() function of mysql to put out it, like this:

$result=mysql_query("UNIX_TIMESTAMP(G.when) from nucleo WHERE bla bla");

duckula

I use mySQL UNIX_TIMESTAMP for tracking logins, but for this particular problem I cannot work out that the stored unix timstamp that was derived from a dd/mm/yyyy date does not return the same date after converting it back to dd/mm/yyyy.

duckula

Any more ideas / assistance would be appreciated, thanks...