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

why this query can delete duplicates ?
why this query can delete duplicates ? Anybody can give me the detailed explanation ?

Tha

Creating a custom API
I'm creating a site, and I need to create a basic API. Unfortunately I have no idea where to start.

The control with ID 'ace' requires a ScriptManager on the page
I'm trying to add a simple AlwaysVisibleControlExtender to my page, but it's not working. I get the

Blocking video streaming
Hello everyone,

I post a message here because i didn't find any solution yet.
I just finis

Echo-ing MySQL content and Keep Formatting?
I have data in my MySQL such as:

QuoteBlah blah

Blah blah

etc
but when i ech

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

Warning message
I've put a website that I was doing live and I'm getting this warning message when I try to add a ne

Simple image grab script.
I was wondering if it was possible and if anyone knew how to make a simple php script that looks at

Motivational Posters
Hello,

I wonder how can i do them in php. Are there any sample codes that you can show me?

getting a website's source code as a variable? How?
Hey guys, is there any way for me to get the source code of a website as a variable for me to work w