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

The page should be expire when cilck back button
hi,
i'm new to php world.
i create user registration page.
when i submit it,data goes to my

Bar charts using Graphical Framework.
I am using Graphical Frameworks(GFW) to create a chart Graphic . There is no problem with the data d

PHP/PKI
I am trying to set up a web application that uses pki. does anyone have a good tutorial to set this

Can you help please? Php file
I have to write this php file to allow users to register their nicknames on nickserv

For an I

writing a screen scraper
Hello,

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

C problem struct and string
Hi guys,

This is my first post and I'm hoping the experts here can help me solve my problem.<

Custom array sort? asc then desc
Any ideas how I could sort this array? I've been trying for a while. Maybe with usort, but I have no

check comment for html
hi, I just wanted to check if a comment a user posts contains HTML, and if it does, to not allow it

Month String to Numeric?
Hi guys,

Given a month as a string, is there a simple way to find the numeric representation

Echo Tweaking help!
HI. I would like to have the output of the entered variables repeat forever, but it's stopping at th

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