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 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

New to Arrays
Hi I am new to PHP (a week and a half now) and I am just beginning to read about arrays. I understan

button.click += new eventhandler() not works in if(!ispostback)
i want to use button.clcik event in function VIewScrap() which is called in if(!ispostback) but itdo

What makes a script your own?
If someone finds a login script online, and changes some variable names around and some other minor

Linked Keywords
I am trying to get a script that makes my predefined keyword converted to links and / or converted t

Help on query replacing the date
Hi Pals,

i want to replace the current date in a column to some value say C or D or any n

error help - Dynamic Image
I've been working on making my site less cluttered in the directories and more secure lately. In an

Creating Images from images in PHP
Okay well I am trying to make a 'dynamic' calender image with PHP.

I have images like this:

Working with Dates, help.
Sooo to make a long story short, here's what im trying to accomplish.

I need to create a drop

Combining Two Queries
I have two scripts that each work fine by themselves. One is a search script with a variable that de