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

Supress some serveroutput but not all
Hi,

I have a script I'm working on that uses plsql to create and RMAN script, this uses d

Script not running properly
Hello Everyone
This is a basic script for posting to a database. I'm not sure why it doesn't work

Searching keywords from array
Hello everyone, Im just wondering if someone could help me with another issue im having. Im still le

Problem with shopcart code
Hello, I am having a bit of trouble being able to add a product to my shopcart. My mysql database i

Problems with strings containing
Hey all,

I have encountered something strange in a script. I am trying to write an XML heade

gmmktime or mktime
I live in the UK, i am within the GMT (with daylight saving time ie 1 hour difrence between summer a

please fix the error
What is the error in the below code ???
Line number On/Off | Expand/Contract <?php

Can't shake the "Warning: include()" error
I've just uploaded my site to a new server and where I have PHP include tags in my HTML, the browser

Help with some dates
I have a list of dates in an array:

$mondays = array(
strtotime("October 12, 2009

listing help
Hi,

at first, great new design!!! I like it,

i got a problem,

I want to list so