Date Question

Posted on 16th Feb 2014 07:03 pm by admin

I'm using the TIMESTAMP() function within mysql to set the date/time for certain events. However, how would I go about formatting the output? For example it would display "2009-11-30 02:48:40".. how can I change that formatting around?

Also, I wanted to do a sort to display items within my table monthly.. is there anything I can use to only pull/sort data by the month?

Your Answer:

Login to answer

Other forums

How to add functionality to a simple php calender?
Hello everyone,

I have just finished creating a simple php calander. Can someone point

Search in the PHP Files
have to search asterisk(*) in the php code of the php files .
In the html page one text box

Add User script "Could not execute query"
This should be an easy script but I can't get it to run. Can someone please help me?

<

insert PHP code into function
Hi,
I'm having problems when trying following:

I have:
Code: [Select]createBar("Do

how to validate date using javascript
I need to validate date in textbox using javascript..
The date is must be not greater than TODAY

parsing error
can anyone explain this syntax error:

Parse error: syntax error, unexpected T_IF

The e

Saving data from a form into a file
Hey everybody,

Sorry, I am really new to PHP coding and such but a project kind of got thrust

moving mouse to display image coordinates
I have an existing MFC application that shows an image in the main window.
I'd like to be able to

Disable html within defined tags
I have a mysql database that allows users to enter content with html, but I also want to have a tag

$get problem
Hi Guys ...

can you please tell me what i am doing wrong here
Code: <?php