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

Sessions work for me and not others?
I'm having a bit of bad luck with sessions. In the past they have worked fine for me, but this time

Trying to add functions to table
I have this list of characters and I'm trying to figure out what I have to do to put the results of

Slashes
Have a small problem and I'm not able to understand why I'm getting the results I'm getting... and i

Table Control
Hi Guru's,

I've created a Module pool program, which contains the Table Control.

Map.php
I am a complete beginner to PHP and am looking for some help with a program I am messing around with

Deleting Partners on the Customer Master.
Does SAP handle removing the Partner from Open Sales Orders when a Partner is deleted in the Custome

What do you call the "token" thing?
You know how some sites have links that run on tokens? Tokens are links that only stay alive for a c

I need an iframe that calls up a different page according to the date
hi

I don't know any php (only html) and I urgently need to do the following:

I need a

Get to know your fellow coder
I think it's time we got personal around here. There's a lot of code swapping and a few members kno

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