date formatting

mdojet

I found a script that puts a date stamp in my database. I went into the database and found this: 1098770400.

I dont understand those numbers. Here is the script that was written.

//Get today’s Date
$date = date("m/d/Y");
//Get today’s timestamp at 12:00am
$date = explode("/",$date);
$my_time = mktime(0,0,0,$date[0],$date[1],$date[2]);

Can anyone help me decipher what was put in my database?

Thanks!

Mike

rachel2004

You're looking at a Unix timestamp (the number of seconds that have passed since January 1, 1970).

feshmania

you need to format the date.

for instance:

$date = date("l  F d , Y h:i A", time()+60*60*3);

that would set the time to the UNIX day on East Coast Time. So, for instance, my server is on the west coast. I need to increase its time by 3 hours (that's where that "*3" comes from).

The format would look similar to this (understanding that the given date/time is January 1, 2005 1:00PM):

Saturday January 1, 2005 1:00 PM

hope that helps.

if not, check here

mdojet

Actually I dont care what the date stamp looks like in the datebase because it will be used later to see if my user's membership has expired..ie...in 60days, etc. I was just wondering if that entry in my database was legit or garbage. But if I write a script later to compare todays unix timestamp with that on in my database, that is all I really want. Do I still need to reformat it? Thanks for the help..you guys are great!

Mike

rachel2004

Mike, if you plan on doing date comparisons, you want to work with the Unix timestamps since you can subtract one from the other as one way to determine an interval.