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?

Did you know?Explore Trending and Topic pages for more stories like this.
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

Trouble checking SESSION cookie
I am trying to use $_SESSION cookies to verify admin privileges .
I don't understand why this is

PRotect my POST DATA... FROM HTML ATTACKS
I need to like let's say

If a user submit's his Prayer and he put's <meta refresh stuf

Count
Getting the same count everytime

Code:
$visitquery = mysql_query("SELECT COUNT(*) FR

A problem with my GD class
Hello,

I created a nice (and simple for now) GD class.
The problem is , it works great on

Session login issue
I'm wondering how to fix a problem I'm having with a session-based login system

Say I go to h

FTP Programs
Here is a list of commonly suggested FTP Programs to use:

FileZilla
SmartFTP
CuteFTP

writing a screen scraper
Hello,

I'm writing a screen scraper application and want to be able to get absolute addresses

need help in update query
i create a form for update. there are 8 columns in my mysql table. on my main page all the data is r

Using insert variable
need a way to inert variable data to mysql database

$acc = "212121212";
$nok =

Multi-image upload problems
Lets see if I can get some help on this one. Can anyone show me what I am doing wrong here. I'm just

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