Displaying date 1970-01-01 instead of right date.

Question

daniel36 -7 Light Poster

13 Years Ago

Displaying date 1970-01-01 instead of desired date. my code is

date('Y-m-d',$rtTransaction->getAddedOn());

the date returned by the function is in format '1353658977',Please help me. Thank you.

php

6 Contributors
21 Replies
452 Views
2 Days Discussion Span
Latest Post 13 Years Ago Latest Post by daniel36

Dani AI

Generated 9 Months Ago

A short, practical addendum that ties the earlier replies together and gives a concise debugging checklist and safe fixes — useful later if the same symptom appears again.

Common root causes

The epoch date appears when the value used for conversion is missing, zero, or not an integer timestamp. and were correct to point to the value itself; ’s final comment about removing the WHERE clause strongly suggests the filtering/formatting of dates (or a type mismatch) was masking the stored values.

Quick checks (run on the server/DB)

Confirm the column type and how values are stored:
```
SHOW COLUMNS FROM rt_transaction LIKE 'added_on';
```

Inspect raw stored rows and a numeric view to compare formats:

SELECT added_on, UNIX_TIMESTAMP(added_on) AS added_on_ts
FROM rt_transaction
WHERE rt_owner_id = 'theOwner'
LIMIT 10;

Safe PHP-side debugging and handling

Log raw values and detect whether the DB returned an integer or a datetime string, then handle both paths. Example pattern:

error_log('added_on raw: ' . var_export($row['added_on'], true));

if (is_numeric($row['added_on'])) {
    $dt = new DateTime('@' . (int)$row['added_on']); // epoch seconds
} else {
    $dt = new DateTime($row['added_on']); // DATETIME/TIMESTAMP string
}
// format in local timezone if desired:
$dt->setTimezone(new DateTimeZone(date_default_timezone_get()));
echo $dt->format('Y-m-d');

Practical recommendations

Make sure form dates are validated and quoted correctly before they reach SQL; prefer prepared statements.
If the WHERE clause removal “fixed” the output, inspect how the clause was built (string concatenation, missing quotes, wrong function usage) — that’s where rows were being filtered or values coerced.
Treat 0 or NULL as “missing” and handle explicitly (log an insertion bug or fallback value).

Credit notes: and gave the key observations; ’s small correction about using the correct debug function was also helpful.

All 21 Replies

broj1 356 Humble servant

13 Years Ago

1353658977 seem to be date in unix timestamp which converts to Fri, 23 Nov 2012 08:22:57 GMT. If you get 1970-01-01 something must be wrong since the unix timestamp for this date is 0. If $rtTransaction->getAddedOn() returns timestamp then it ovbiously returns 0.

Edited 13 Years Ago by broj1

Member #949455

13 Years Ago

Displaying date 1970-01-01 instead of right date.

I find it odd that you want to change the display date on an transaction that is 23 years ago. May I ask why you need to change the date that far back?

Edited 13 Years Ago by Member #949455 because: grammer

Member #120589

13 Years Ago

The second parameter in date() must be an integer greater or equal to 0. NULL, false, 0 and negative numbers will give 1970-01-01. Strings will give an error. So, you need to investigate the return value for the method $rtTransaction->getAddedOn()

broj1 356 Humble servant

13 Years Ago

To restate the above answers: the method $rtTransaction->getAddedOn() presumably returns a unix timestamp which you want to convert to human readable date. If the displayed date is 1970-01-01 then the $rtTransaction->getAddedOn() method has returned 0 which is a timestamp that translates to 1970-01-01. As said above: investigate the $rtTransaction->getAddedOn() since the error is quite possibly there. You can also post the method here.

Member #120589

13 Years Ago

i did not get proper answer

Yes you did.

how can i fix the problem to get correct date from code?

Read posts by broj1 and myself. We do not have a crystal ball to know which value your method is returning.

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

daniel36 -7 Light Poster · Answer 1 · 2013-01-08T11:40:27+00:00

i did not get proper answer,how can i fix the problem to get correct date from code?

NardCake 30 Posting Pro in Training · Answer 2 · 2013-01-08T12:24:48+00:00

I don't understand what you are trying to do. If you just need to display a specific date just echo it out as a string...

daniel36 -7 Light Poster · Answer 3 · 2013-01-09T10:37:08+00:00

Yes sir you are right ,i have changed upper code with date("Y-m-d",$vrow['added_on']) ,but the $vrow['added_on'] is reruning 0.i am unable to understand why is it?

daniel36 -7 Light Poster · Answer 4 · 2013-01-09T10:44:22+00:00

daniel36 -7 Light Poster

13 Years Ago

i am fetching this value from database .

daniel36 -7 Light Poster · Answer 5 · 2013-01-09T11:04:20+00:00

I am unable to fetch the value in database in 'added_on' column.other values are previewing correctly.but this is showing only 0.

broj1 356 Humble servant Featured Poster · Answer 6 · 2013-01-09T13:05:20+00:00

What is the query that reads the values from the database? Does the value exist in the added_on column? Does any data for the query come from a form?

daniel36 -7 Light Poster · Answer 7 · 2013-01-09T13:29:55+00:00

my query is-

$vquery="SELECT * FROM rt_transaction WHERE added_on>=Unix_Timestamp(".$date1.") AND added_on<=Unix_Timestamp(".$date2.") AND rt_owner_id='".$_POST['owner']."'";

in which date1 and date2 are coming from the form.and also added_on column having the value.thank you for your response.

daniel36 -7 Light Poster · Answer 8 · 2013-01-09T14:00:13+00:00

daniel36 -7 Light Poster

13 Years Ago

the date is in format-yyyy-mm-dd.

broj1 356 Humble servant Featured Poster · Answer 9 · 2013-01-09T19:45:56+00:00

Do you do any checking on dates that come from the form i.e. are the dates in correct format or is date2 >= date1 etc? I suggest you put the debug code just after the SQL statement:

$vquery="SELECT * FROM rt_transaction WHERE added_on>=Unix_Timestamp(".$date1.") AND added_on<=Unix_Timestamp(".$date2.") AND rt_owner_id='".$_POST['owner']."'";

// DEBUG
die($vquery);

This code will display the query and stop the script. Please test the displayed query in phpmyadmin or mysql client (assuming you use mysql) or post it here.

daniel36 -7 Light Poster · Answer 10 · 2013-01-10T06:41:30+00:00

daniel36 -7 Light Poster

13 Years Ago

the mysql query is working right.

broj1 356 Humble servant Featured Poster · Answer 11 · 2013-01-10T08:41:31+00:00

broj1 356 Humble servant

13 Years Ago

Can you post the whole code.

daniel36 -7 Light Poster · Answer 12 · 2013-01-10T09:18:27+00:00

yes sir,my code is

IF(isset($_POST['view_all_report']) || isset($_POST['view_owner_report']))
          {
        //$columnWidthList=array(20,40,25,16,40,20,25);
          $columnWidthList=array(20,40,52,25,25,25);
        //$headerList=array('Txn Id', 'Txn Date', 'Amount', 'Type','Payment Method','Status','Balance');
          $headerList=array('Txn Date', 'Txn Unit', 'Description','Income','Expend','Balance');


  IF(isset($_POST['view_all_report']))
      {
         $date1=$_POST['from'];
         $date2=$_POST['to'];
         $vquery="SELECT * FROM rt_transaction WHERE added_on>=Unix_Timestamp('".$date1."') AND added_on<=Unix_Timestamp('".$date2."')";
         $vresult=mysql_query($vquery) or die(mysql_error());
         die($vquery);

        $dataList=array();
        while ($vrow=mysql_fetch_assoc($vresult))
             { 
        $wquery="SELECT rt_user_name FROM rt_user WHERE rt_user_id='".$vrow['rt_owner_id']."'";
        $wresult=mysql_query($wquery) or die(mysql_error());

       while($wrow=mysql_fetch_assoc($wresult))
              {
                 $txnunit=$wrow['rt_user_name'];
              }  

        IF($vrow['rt_txn_type']=='C')
           {
             $income=$vrow['rt_txn_amount'];
             $spend=0;
             $balance=$vrow['rt_txn_amount'];
           }
         else
          {
             $income=0;
             $spend=$vrow['rt_txn_amount'];
             $balance="-".$vrow['rt_txn_amount'];
          }
        $dataList[]=array(
                                //$rtTransaction->getRtTxnId(),
                                date("Y-m-d",$vrow['added_on']),
                                $txnunit,
                                $vrow['rt_txn_desc'],
                                $income,
                                $spend,
                                $balance
                            );
        }

        $pdf = new PDF();
        $pdf->setDataList($dataList);
        $pdf->setHeaderList($headerList);
        $pdf->setColumnWidthList($columnWidthList);
        $pdf->SetFont('Arial','',9);
        $pdf->SetRightMargin(5);
        $pdf->AddPage();
        $pdf->generateBasicTable();
        $pdf->Output(); 
       }

broj1 356 Humble servant Featured Poster · Answer 13 · 2013-01-10T10:18:16+00:00

Can you comment out the die statement on line 16 and insert this debug code after line 20 (in the beginning of the while loop):

if($vrow['added_on'] <= 0) {

    die($vrow, 1));
}

This will output the value of the $vrow in a case where $vrow['added_on'] equals 0 or less than 0. You have to investigate that row then. Please post the result here if you do not manage to debug the error yourself.

daniel36 -7 Light Poster · Answer 14 · 2013-01-10T11:12:58+00:00

This is not working .giving error
Parse error: syntax error, unexpected ',' in /opt/lampp/htdocs/rent/admin/rttransaction.php on line 200

pritaeas 2,276 Most Valuable Poster Moderator Featured Poster · Answer 15 · 2013-01-10T11:56:42+00:00

pritaeas 2,276 Most Valuable Poster

13 Years Ago

Line 3 above should be:

die($vrow);

daniel36 -7 Light Poster · Answer 16 · 2013-01-10T12:13:48+00:00

sir i have solved this.I removed the where clause and use conditions later.very very thank you for your response.

Displaying date 1970-01-01 instead of right date.

Dani AI

Recommended Answers Collapse Answers

All 21 Replies

Recommended Answers