Formatting Medium Date Using PHP

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Ollie56
    New Member
    • May 2007
    • 1

    #1

    Formatting Medium Date Using PHP

    Hello,
    I am looking for some guidance on how to format a date field as DD/MM/YY when displayed using a PHP script. The field format used in the database is medium date.
    Thanks in advance for your help.
  • nico5038
    Recognized Expert Specialist
    • Nov 2006
    • 3080

    #2
    Not sure how PHP works with Access, but in an Access query you can use:

    select format(datefiel d,"dd/mm/yy") as FormattedDate, ...

    to format the resulting datefield.

    Nic;o)

    Comment

    • NeoPa
      Recognized Expert Moderator MVP
      • Oct 2006
      • 32669

      #3
      I think this question is probably more appropriate to the PHP forum so I'll move it there. I'll leave a link here for anyone interested.

      Comment

      • pbmods
        Recognized Expert Expert
        • Apr 2007
        • 5821

        #4
        Heya, Ollie56. Welcome to TSDN!

        Originally posted by Ollie56
        Hello,
        I am looking for some guidance on how to format a date field as DD/MM/YY when displayed using a PHP script.
        Have a look at date and strtotime.

        Comment

        • NeoPa
          Recognized Expert Moderator MVP
          • Oct 2006
          • 32669

          #5
          Thanks pbmods.
          And Ollie, don't be put off by the 'face'. He's not that frightening really ;)

          Comment

          Working...