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

utf8_general_ci error ??
I have all kinds of data to be inserted in database table

//I am getting this error

Yo

getting most records by count
Code: [Select]<?php

$connect = mysql_connect("localhost","dam

Transaction variant for VA02 not working
My requirement is to have transaction for user to only add the output and print a sales order.

Preloading images
Posting this question here because I am not sure where this should belong.I am building an asp.net a

Little problem with form insertion in MySQL, Please help!!!
Hi!,

I'm a little bit new with php and I have a little issue here. I created a webform to ins

uploading video files into mysql in php
hi,
I have the video files which i have to upload into mysql db. along with creating thumbnails f

Only add new information from XML to MySQL
What I am doing, is taking a xml file, and adding the values to a database. However, what I want to

Material xxx does not exist in plant xxx
Dear All,

I am working for a steel project which is repetitive manufacturing.

Kill a process
I have a question - how can I kill a process from a command line or by using Oracle SQL Developer? I

Just wondering what you think about my site
I am new to phpfreaks i just seen this form and thought it would be cool to see what other thought a