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

what does this mean? +=
is anyone able to explain what this code is saying?

i had it written for me awhile back and n

Multiple if statements
Ok so seems basic but for some reason I'm not doing it right. What I want is to be able to have 2 se

PHP Mysql Staff Induction System
Hi there, I'm pretty new to PHP and Mysql so could really do with being pointed in the right directi

Displaying Site Logo/Icon on a Title tag
really need some help out here. I want to insert a Logo/Icon just like the one close to the "PH

Simple MySQL query...
Hello,
How could I do a mysql query that does this: SELECT * WHERE date/time < 5minutes ag

Help with lottery style system?
I'm working on a currency system for forums and it is going to have a type of lottery system built i

pointer 102 question
I read a book
1
2
3
4
5
6
7
8
9
10
11
12
int main() {

Simple AND question
Hello,

I've got following code:

Code: if(strpos($row[13],"http://")

Connect to database that isn't localhost
I am currently doing a small script for a company that doesn't have mySql support on there hosting.

DBCA Templates
Hi all,

I'm working on creating a template for DBCA, but can't find any documentation on the