List:General Discussion« Previous MessageNext Message »
From:bharani kumar Date:September 26 2009 9:10am
Subject:Query :: Finding Date Difference
View as plain text  
courier_id consignor_name consignor_address consignor_destination
consignor_phone
consignee_name consignee_address consignee_destination consignee_phone s_date
s_date_mm s_date_ss r_date r_date_mm r_date_ss consignment_description
no_packages
weight frieght_charges loading_charges unloading_charges tax amount
remarks courier_status
user_id consignor_email consignee_email status   [image:
Edit]<http://localhost:91/tbl_change.php?db=seva360&table=courier_details_tbl&token=dc325199a0d6782e1a4bbb6f96ec0ff8&primary_key=+%60courier_details_tbl%60.%60courier_id%60+%3D+1&sql_query=SELECT+%2A+FROM+%60courier_details_tbl%60&goto=sql.php>
 [image:
Delete]<http://localhost:91/sql.php?db=seva360&table=courier_details_tbl&token=dc325199a0d6782e1a4bbb6f96ec0ff8&sql_query=DELETE+FROM+%60courier_details_tbl%60+WHERE+%60courier_details_tbl%60.%60courier_id%60+%3D+1+LIMIT+1&zero_rows=The+row+has+been+deleted&goto=sql.php%3Fdb%3Dseva360%26table%3Dcourier_details_tbl%26token%3Ddc325199a0d6782e1a4bbb6f96ec0ff8%26sql_query%3DSELECT%2B%252A%2BFROM%2B%2560courier_details_tbl%2560%26zero_rows%3DThe%2Brow%2Bhas%2Bbeen%2Bdeleted%26goto%3Dtbl_structure.php>
1 gfdsgdfs gdfsgsdf gdfsg 43534 gdfsg gfdsgs gfdsgdf 5435345 2009-10-02 05
15 0000-00-00     fadsfads 33 23 23 2 3 3 32   1 1     0  [image: With
selected:]


Hi All ,

Above is my table structure , table name is
*details_tbl<http://localhost:91/tbl_structure.php?db=seva360&table=courier_details_tbl&token=dc325199a0d6782e1a4bbb6f96ec0ff8>
*
<http://localhost:91/tbl_structure.php?db=seva360&table=courier_details_tbl&token=dc325199a0d6782e1a4bbb6f96ec0ff8>

Am working in courier project ,

Once the goods despatch , then we show the staus as sent ,

Assume if user , track the courier after 30 day's ,

Then i have to show the message contact admin ,

If they tried with in  30 days , then i have to show message , like courier
SENT / PEND /  FAILED ,


Can u please tell the query ,

If the *r_date *(recive date)  greater then of 30 days , they i have to show
message like contact admin....


Please tell the query ,

Thanks

Thread
Query :: Finding Date Differencebharani kumar26 Sep
  • Re: Query :: Finding Date DifferenceColin Streicher27 Sep