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

php multiple action on submit
I have a form which says:

<form enctype='multipart/form-data' method='post' action='pr

Inserting the current date/time while submitting the forum
What do I need to add below to update the current date/time? I have a field in the database called d

get multiple rows
Hi I want to get multiple rows from a db

I am using this for the db query
Code: public

Please help - should be a simple fix.. driving me nuts
Everything seemed to be working fine. I have a table, it alphabetically lists a bunch of cities and

strtotime issue
Hey all,

I'm playing around with some code, and basically the idea is:

Person changes

Saas with SAP R/3
hi experts,

Is SaaS offer available in SAP? for SAP R/3? from where i can get the info a

Update Database
Hi All,


I have a problem with this:

Code: [Select]<?php
session_start();

$get problem
Hi Guys ...

can you please tell me what i am doing wrong here
Code: <?php

Spliting paragraph into sentences and attach in
Here is what I am trying to do

example: Para1[123.456.789!] 3 sentences
Para2

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