Welcome to collectivesolver - Programming & Software Q&A. A website you can trust. All programs tested and work.

aviboots(AT)netvision.net.il

Instant Grammar Checker - Correct all grammar errors and enhance your writing
BlueHost Web Hosting

Bonsai Boy of New York Bonsai Trees and Accessories

Website Domains Names & Hosting | Domain.com

Instant Grammar Checker - Correct all grammar errors and enhance your writing

Ecommerce Software - Best Ecommerce Platform Made for You - Free Trial

DreamHost Web Hosting


Liquid Web Cloud VPS Hosting

Disclosure We are a professional Programming & Software Q&A website, that receives compensation from some of the links whose we show you with Information. It means that my content may contain affiliate links.

13,252 questions

18,038 answers

573 users

How to format SQL NOW() Function (current system date and time) in MySQL

3 Answers

0 votes
SELECT FirstName, Salary, DATE_FORMAT(NOW(), '%m-%d-%Y') AS w_date
FROM workers

--  FirstName 	Salary 	    w_date 	
--    aaa 	    3000.45 	10-14-2015
--    bbb 	    6000.55 	10-14-2015

 




answered Oct 14, 2015 by avibootz
0 votes
SELECT FirstName, Salary, DATE_FORMAT(NOW(), '%d %b %y') AS w_date
FROM workers

--  FirstName 	Salary 	  w_date 	
--  aaa 	    3000.45   14 Oct 15
--  bbb 	    6000.55   14 Oct 15

 




answered Oct 14, 2015 by avibootz
0 votes
SELECT FirstName, Salary, DATE_FORMAT(NOW(), '%b %d %Y %h:%i %p') AS w_date
FROM workers

--  FirstName 	Salary 	   w_date 	
--    aaa 	    3000.45    Oct 14 2015 09:42 AM
--    bbb 	    6000.55    Oct 14 2015 09:42 AM

 




answered Oct 14, 2015 by avibootz
...