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

Transaction variant for VA02 not working
My requirement is to have transaction for user to only add the output and print a sales order.

Save cookie to DB
I'm working on a pixel tracking script for an incentive website and I need to use an ASP script to s

Image DPI
Hi.

I allow users to upload images, the user then is able to adjust several settings for the

Help with PHP Email Script
Hi guys,

I'm a newbie to php and need help with the script below:

At the moment when I

Add code to enable passing of checkbox variable on login
Ok, I have a login page, but want to add a checkbox that when checked and successful login is made i

Oracle11g Patch issue
Hi all,

I'm getting the following error while installing Oracle11g Patch 11.1.0.7.0 on IBM-AI

Advice on how to delete a mysql row using my form
Hi,

I am very new to php and am struggling to work out how to delete a portfolio item (a row

Error with login script
I am getting an error with my login script:

Error:
Code: Warning: Cannot modify header inf

Save file by click
Hello.
I'm not understand how to save file from page. I'd like make link to file with save abil

PHP form help required
Hi all! Apologies in advance for having to message the forum for help. I know you must get a lot of