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

ALV List Display to point to another report on Double Click
Hi,

I want my ALV List Display to point to another report on Double Click on its line ite

Form submissing with PHP and JQuery/Ajax
I have searched everywhere, but cannot find a solution for this... I have worked all day trying to g

FlashVar function how to insert variables
Hi guys. Im new in this forum and also new in php programming. Can you help me about this code?
<

NOOB needs help with upload file
The intent of this form is to create a folder for a client and upload an image into another folder '

A Few Questions
Hi, I want to ask a few questions that I can't seem to find..

1) I'm creating a "shortcu

urldecode question
How would I format this line of code properly?

<?php echo urldecode($_GET['Title']); ?

Need help making a script that moves data into acrhive table
Hi,

I'm kinda new to php/mysql

And i wrote a simple script to store sales lead for a b

how to make database item unique
Hey guys,

is it possible to do this:

I have the database item $title being pulled for

How to give the privillege for triggers?
Hi,

How to give the privillage for triggers to particular user?

Please let me

Load Animated Image while cache is serve
I have a page that loads up using cache and took about 1 to 2 minutes before it loads to the page. <