Timestamp problem

[krappleby025]

I am pulling data from a database timestamp field, and trying to generate a formated date form it. however i have a problem...

The coding im using is

$newdate = date("d/m/Y",$signdate);
(signdate being the timestamp field)

the var $newdate, produces 18/01/2038

however...

the timestamp states

20031026134827

which as you can see should read 26/10/2003

so why is it instead producing 18/01/2038.

any ideas

thanks

 

[sleipnir214]

IAW

http://us4.php.net/manual/en/function.date.php,

date() takes two inputs, one required, one optional. The first input parameter is required and is the format string for the date you wish the function to produce. The second optional one is an integer which enumerates, in seconds, the time since the beginning of the Current Unix Epoch (1970-01-01 00:00:00).

You are handing the function a string that looks like an integer, so date() calculates the date wrong.

The PHP function strtotime() (

http://us4.php.net/manual/en/function.strtotime.php)

can take a date string and produce the CUE timetick.

Combining the two, you can do something like:

$newdate = date("d/m/Y",strtotime($signdate));

and get the right date.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[krappleby025]

thanks, i will look at the sites, but with your example im now getting
31/12/1969

way out lol

thanks

 

[sleipnir214]

It sounds to me like strtotime() doesn't understand your date string format. You might consider performing the format on the MySQL side:

SELECT date_format(dt, '%d/%m/%Y') from foo;

(

http://www.mysql.com/doc/en/Date_and_time_functions.html)

or do it on the PHP side without using strtotime:

<?php
$timestamp = '20031026134827';
$timestamp = preg_replace ('/(\d{4})(\d{2})(\d{2})(\d{2})(\d{2})(\d{2})/', '$3/$2/$1', $timestamp);
print $timestamp;
?>

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!