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?

No comments posted yet

Your Answer:

Login to answer
51 Like 32 Dislike
Previous forums Next forums
Other forums

SuperCali PHP Event Calendar
does anyone have any experience with the SuperCali PHP Event Calendar? I could use some assistance

Weird MySQL error, why am I recieving this?
PHP Code:


<?php require "global_settings.php"; ?>
<titl

problem with refreshing
in my site, i have an index page, it has a main div. this main div's content is changing according t

Different actions for different parts of a string
<?php
function dosomething($string, $else = '') {
if (empty($else))
$string

Making multiple rows with one query
I have a table called efed_handler_characters with two fields handler_id and bio_id. What query 2 is

re calling a function without including file
Hi,
i am new to programming in php, i was just checking the wordpress code and found out in the w

Problem!
I have another problem, when i run this code i get this error "Parse error: syntax error, unexp

Request.UrlReferrer
I need to make it so that a page can only be loaded when a button is clicked on a specific page. I d

How do I send data using an html link
Hi

If I have
<a href="main_file.php">

How do I send data t

recrawling
Can anyone suggest me how may i know a page is updated before it is being downloaded, so that i can

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash