Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2003
    Posts
    137

    Unanswered: how to convert the GMT field?

    I have a date field stores dates in GMT but i want to show it in Arabian Standared Time. Our local time is GMT + 3 (and GMT + 2 in summer)?

  2. #2
    Join Date
    Apr 2003
    Posts
    137

    plz URGENT help is required

    I am using this code to read the data..

    $billing_sql = "SELECT billing.billing_id, billing.detail, billing.start_date_time, billing.amount FROM customers INNER JOIN (accounts INNER JOIN billing ON accounts.account_id = billing.account_id) ON customers.customer_id = accounts.customer_id WHERE customers.customer_id = '".$_SESSION['customer_id']."' AND billing.entry_type IN(1,2,5,6,7,8) ORDER BY start_date_time desc LIMIT 10";

    $billing_result = pg_exec($pg_connection, $billing_sql);

    $billing_date_time = pg_result($billing_result, $i, 2);


    and I need to display the date in GMT+03:00

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •