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

 formating when pulling data from a mysql database 
Ok so Im not to sure if this is the right thread to post in but here is my catch 22 issue.

I 
PRotect my POST DATA... FROM HTML ATTACKS 
I need to like let's say

If a user submit's his Prayer and he put's <meta refresh stuf
Problem in OnClientClick and OnClick sync 
Hi,Strange and irritating problem:
 
I have below button declaration in markup of the aspx page:
imap: how to save a copy of sent emails to sent elements 
Hello my friends,

I am writing an online emailing application with inbox outbox/sent elements
At max how many columns is advisable to create in a table/view  
Hi All,

    I have two transaction table from which i want to create a simple view or  material
Xml parsing 
I need a suggestion about parsing xml with multiply parts like pervious... 
i.e. different device
split string 
Hi all 

i have some names (imploded by comma):
Code: toronto,paris,madrid
Now, i would 
(sub)screen resize modification doesn't work after ECC 6 EhP 4 installation 
Hello,



We have previously extended the size of the custom data tab on PO transaction ME23
Format timestamp from mysql 
When I tried this:
Code: date("m/d/Y H:i A", $row['timestamp'])
I got 12/31/1969 18:
image upload script not working with png 
The basic process of this php code is to take the submitted file, convert it to a small JPG thumbnai