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

Remove values in array2 from array1
I have two arrays.

Array 1 is where the array key holds various different numbers. For exampl

Curly Bracket Delimeters.
I'd always believed that the starting and ending delimeters in preg_ functions had to be the same ch

Record count of entire database
Does anyone know if there is a way to obtain the number of records in each table of the database usi

constructor ?
i have written this program and made 3 constructors in the class and i want to call them in the main

error with opendir
when i do this

if ($handle = opendir($dir)) {
while (false !== ($file = readdir($han

form problem
below in the form action, i've put "test.php?w=$sw&h=$sh" but when i input the for

Passing an array of values From VB6.0 to Oracle PL/SQL Function
Basically we are using VB6.0.

When we try to pass an array from VB6.0 to an Oracle PL/SQL

Specific name typed, specific image shown on html page
Hello,

Fairly new to PHP and was curious if someone might know how to solve a fairly simple r

Need understanding of this bit of code
Code: <?php
// WHERE clause filters
$arrSQLFilters = array();

//

textfield unchanged
hi,
i want my form to know whether its textbox is unchange or not.

if($textbox == 'unchang