Converting from timestamp to format:

date('Y-m-d', $timestamp);

Converting from formatted to timestamp:

mktime(0, 0, 0, $month, $day, $year, $is_dst);

See date and mktime for further documentation.

When it comes to storing it's up to you whether to use the MySQL DATE format for stroing as a formatted date; as an integer for storing as a UNIX timestamp; or you can use MySQL's TIMESTAMP format which converts a numeric timestamp into a readable format. Check the MySQL Doc for TIMESTAMP info.

• PHP function that will turn a time stamp in the format yyyy-mm-dd hh:mm:ss into how old the time stamp is

  Basically, I have a time stamp that looks like 2010-12-15 16:14:06 . If the time stamp is seconds old I want it transform it into "N Seconds Old." If the time stamp is minutes old, I want it to tran…

• How to convert date in format "YYYY-MM-DD hh:mm:ss" to UNIX timestamp

  How can I convert a time in the format "YYYY-MM-DD hh:mm:ss" (e.g. "2011-07-15 13:18:52" ) to a UNIX timestamp? I tried this piece of Javascript code: date = new Date("2011-07-15").getTime() /…

• Getting a Date Range in MySQL form a UNIX Timestamp in PHP

  I have a UNIX timestamp in a table like 1321521158 and want to get the details from a table for the particular date, like: $mydate="11/11/2011"; SELECT notes FROM table WHERE `addeddate`=$mydate …

• What is the easiest way to get a yyyy-mm-dd hh:mm:ss timestamp hotkey on the Mac?

  On Windows I use the PSPad editor which has a nice ALT-D timestamp which you can edit the format of, e.g. yyyy-mm-dd hh:mm:ss . When working outside an editor, e.g. Google Docs , I have Autohotke…

• What is the simplest way to format a timestamp from SQL in PHP?

  What is the simplest, fastest way to complete the PHP code below such that the output is in a user-friendly format (for example, "October 27, 2006")? $result = mysql_query("SELECT my_timestamp FR…

• How do I format a date to mm/dd/yyyy in Ruby?

  In Perl you can do: my $current_time = DateTime->now(); my $mdy = $current_time->mdy("/"); What's the easiest way to do this in Ruby?

• Convert US date format to ANSI SQL date format (YYYY-mm-dd)

  I want to convert user-submitted date format (mm/dd/yyyy) to a MySQL date format (YYYY-mm-dd). Submission is via a simple PHP form direc tto MySQL database.

• Convert mm/dd/yy to mm/dd/yyyy in PHP

  I'm working on a project that requires me to read values from a file and manipulate them slightly before storing them elsewhere. One of the things I need to do is convert some dates from mm/dd/yy fo…

• MYSQL: Convert Timestamp --> Time

  I have this MYSQL Table: [ID] [TIMESTAMP] [TIME] [1] [2010-05-29 01:17:35] [] [1] [2010-05-29 01:23:42] [] ... and so on Now I need to copy the TIMESTAMP value into the TIME rows. The new …

• Is there an easy way to get a Unix timestamp from an SQL timestamp in php?

  My database table has a column that contains SQL timestamps (eg. 2009-05-30 19:43:41). I need the Unix timestamp equivalent (an integer) in my php program. $posts = mysql_query("SELECT * FROM Pos…