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

max() problem
I have a while loop to get image names.
Code: $imagequery = mysql_query("SELECT * FROM ad_i

Sending an SMS Message with ASP.NET
Often times it may be a requirement for your web application to send an SMS message. Such examples w

how to get different value in second view of webdynpro?
hello guys,

In ABAP webdynpro I am trying to create one application having two views.

foreach and array need help combining
Hi guys.

Here's the code

Code: array(
'tag' => 'code',<

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

Run function every 5 mins ??
I have a function PostMessage()

How can I run it every 5 mins ??

FPDF Help
I've been playing with the FPDF module. I was building a form and rolling right along and then sudde

Advice on how to delete a mysql row using my form
Hi,

I am very new to php and am struggling to work out how to delete a portfolio item (a row

Creating a unique 'control panel' for each user
Hi there,

I'm thinking of designing a site that will allow users to sign up and have their ow

use an array from 1 class in a second class
I have a class that adds data to an array

Then I have a second class and I need to check if t