Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 4 of 4
  1. #1
    New Coder
    Join Date
    Nov 2003
    Location
    Portugal
    Posts
    15
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Unhappy time format (once again, pls)

    how can i have the output of the following code line:

    <td>".$data ["invoice_date"]."</td>

    in the d/m/Y format.

  • #2
    Senior Coder Nightfire's Avatar
    Join Date
    Jun 2002
    Posts
    4,265
    Thanks
    6
    Thanked 48 Times in 48 Posts
    How does the date look now?

  • #3
    New Coder
    Join Date
    Nov 2003
    Location
    Portugal
    Posts
    15
    Thanks
    0
    Thanked 0 Times in 0 Posts
    2003-28-12

  • #4
    Senior Coder Nightfire's Avatar
    Join Date
    Jun 2002
    Posts
    4,265
    Thanks
    6
    Thanked 48 Times in 48 Posts
    In your sql query:

    PHP Code:
    $query "SELECT DATE_FORMAT(invoice_date,'%D/%M/%Y') AS invoice_date"


  •  

    Posting Permissions

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