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

How to use Substr
I want to check for the word CATEGORY: inside a string which can be CATEGORY: ITEM
and remove the

Question about ShowWindow()
Hello....

I'm struggling with sumpin, and I hope y'all can help.

I've got a CFormView

please hep to get values from a table row
can anyone tel me how I can select and get data from one row by pressing an Edit button in that row

Easy administration on MySQL databases
My website is database driven and I am very tired of manually making queries to my tables in order t

Can't find the problem (no error message)!
OK, here's the deal. This code is really weirdly formatted (sorry!) and hard to understand, so I'm g

very easy question about SQL info
Hello,
I think that I have a very easy question.
I know how to create a form using php SQL and

Using Curl_multi for processing multiple URLs
Hi,

I am at a loss as to how to implement this. I would like to be able to automatically assi

Custom Container in module pool program
Hello everyone,

I have created a custom control in my module pool screen. Now I want to s

Setting/Modify Headers using mail() function
I have a question about setting email headers when using mail() in a php script.

When I send

PHP error. Need help urgently
Hi,

I am programming a php site and have a problem that i just cant find out how to fix. When