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

media recovery
Hi,
i startup the database i got the error

SQL> startup
ORACLE instance started.

quick question about System Change Number(SCN) in FlashBack Query topic
i know tht we can get the SCN of the database using flashback concept as follows

SQL>

Paypal
Hi all,

I have an advanced basic knowledge of php

I want to try something new for a s

Operating System
How in PHP or other language can I detect Operating system, ie Windows XP Home, Windows 7 Ultimate,

Why will this program not run if the variables are not global?
Hey guys I have a kind of perplexing situation that is probably simple, but I can't seem to understa

need help with php get
i have a option box that gets filled with dates, but how do i get once the option value has been cli

pointer 102 question
I read a book
1
2
3
4
5
6
7
8
9
10
11
12
int main() {

PHP SUBMIT
Code: <input name="doLogin" type="image" src="images/loginsubmit.jpg

Variables and Include
Code: [Select]<?php

$header = $_COOKIE['mss']['header'];
$body = $_COOKIE['mss']['b

Libraries in C++
Hi all,

I have two libraries. one is based targeted on linux platform and uses another li