Anyone recognize this date format?

Kwakhed

So I'm working on this site that has this very strange date format and I'm trying to add up totals for all entries yearly. The date format in myphpadmin shows this format: 1169366400. Its very hard to print this date out as well as extract the distinct year out. Help me pls!!:quiet:

tapos

The date format in myphpadmin shows this format: 1169366400.

This is not a date format. Probably this is the time in second. It has saved by using time function of php.

If so you can extract the year easily by using date function.

  $time = 1169366400;
  echo date('m-d-Y', $time).'<br />';
  echo date('Y',$time);

this thing will print date and year.
The output of the above code is

01-21-2007
2007

Kwakhed

Thank you,
helped alot 😃

Kwakhed

One more question: is there anyway I can extract the year in mysql query? I want to link all dates with an array so that everything that has the same Year will be put in the results.

tapos

according to the above format you can't. Because mysql doesn't support this.
Two work with mysql date functions, the date must be in the following formats:

DATETIME	YYYY-MM-DD HH:MM:SS
DATE	           YYYY-MM-DD
TIMESTAMP      YYYYMMDDHHSSMM
TIME	            HH:MM:SS
YEAR	           YYYY

bpat1434

Not true. Please don't be so quick to answer without first looking up to double-check 😉 You can use a few MySQL functions in order to do this:

SELECT YEAR(FROM_UNIXTIME(`timestamp`)) AS `year`, MONTH(FROM_UNIXTIME(`timestamp`)) AS `month`, DAY(FROM_UNIXTIME(`timestamp`)) AS `day`
FROM `table`

It's possible, you just need to use the FROM_UNIXTIME() function which expects a unix timestamp (which is just the number of seconds from Unix Epoch), which is the format you have. Secondly, you have two options: (1) Use the YEAR(), MONTH(), and DAY() functions to get the individual items or use the second parameter in the FROM_UNIXTIME() function to declare an output type. For example:

SELECT FROM_UNIXTIME(`timestamp`, '%Y') AS `year`, FROM_UNIXTIME(`timestamp`, '%M') AS `month`, FROM_UNIXTIME(`timestamp`, '%D') AS `day`
FROM `tablename`

Or simply put:

SELECT FROM_UNIXTIME(`timestamp`, '%M/%D/%Y') AS `date`
FROM `tablename`

tapos

Thank you very much for clearing up this things.