Showing "weekday, date (dd,mm,yyyy)" problem

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • ikkikevin
    New Member
    • Jan 2013
    • 11

    Showing "weekday, date (dd,mm,yyyy)" problem

    Heey all!

    I'm making an upload form, which will also add a date in the database. The date has to look like this format:
    ex. Saturday, 26 January 2013
    How can I do that? What type do I have to choose for the table row?

    Thankss!
  • Rabbit
    Recognized Expert MVP
    • Jan 2007
    • 12517

    #2
    You want to store it as a date or datetime field. The display is just a formatting issue. You can display it however you want but you want to store it as a date or datetime.

    Comment

    • ikkikevin
      New Member
      • Jan 2013
      • 11

      #3
      Do you know what letter combination I have use for that?

      Comment

      • Rabbit
        Recognized Expert MVP
        • Jan 2007
        • 12517

        #4
        I don't know what you mean by letter combination.

        Comment

        • MUJEEB I S
          New Member
          • Jun 2012
          • 9

          #5
          ex. Saturday, 26 January 2013
          the above example not support php mysql database
          the correct format is YYYY-MM-DD
          ex:2007-12-31
          insert this format and select the values from database and change
          it using explode or mktime

          Comment

          • ikkikevin
            New Member
            • Jan 2013
            • 11

            #6
            what is an explode or mktime? ..could you give me an example? I'm kinda new in the php/MySQL world..

            Comment

            • ikkikevin
              New Member
              • Jan 2013
              • 11

              #7
              with letter combination i mean for example: ("HH:MM:SS") or date("Y")

              Comment

              • Rabbit
                Recognized Expert MVP
                • Jan 2007
                • 12517

                #8
                So you're referring to the format string? Here is PHP's documentation of the DateTime::forma t function. http://php.net/manual/en/datetime.format.php

                Comment

                • ikkikevin
                  New Member
                  • Jan 2013
                  • 11

                  #9
                  wel..the problem is more to display it in the format like: ex. Saturday, 26 January 2013

                  Someone has some php-code idea?

                  Comment

                  • Rabbit
                    Recognized Expert MVP
                    • Jan 2007
                    • 12517

                    #10
                    There's an example of it in the link I gave you. Did you even read it?

                    Comment

                    Working...