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

Retrieving innerHTML with cURL?
Hey all (sorry I know I'm a leecher, but I soon won't be. This is my first PHP project, but not my l

Pagination
Okay here is the page in question: http://blenderteachings.000a.biz/tutorials.hamishhill.php

This is driving me nuts!
This insert query looks to be alright, however I get this error:

QuoteYou have an error in yo

Drop Down and text box issue
Is it possible to set a drop down list and text boxes to a certain width?

here is my code

Adding post count
How would I make it so everytime someone clicks submit on my form, their row in the database for the

file downloaded can't be read !!
<?php
$fileName = 'mypic.jpg';
$mimeType = 'image/jpeg';
header('content-dispositio

Do While statement
hi guys,

This may sound trivial but im new to php and as part of an assignmenti have to const

Count on multidimensional array
Hi, i got an array as below:

Array
(
=> Array
(

Embed Video Problem
Hey, thanks for looking!

File to be embedded:

Code: <playlist version="1&q

php mysql query from input textbox
Hi,

I have a text box, in that i have given the mysql query. I can able to get the query in v