Page 1 of 1

date format outside of query

Posted: Mon Aug 22, 2005 7:56 pm
by Jim_Bo
Hi,

Can the following code be set outside of an sql query .. mainly so I dont have to list all the fields within SELECT and use * instead:

Code: Select all

DATE_FORMAT(ADDDATE(last_login, INTERVAL 16 HOUR), '%d-%b-%Y %r') AS last_login

Cheers

Posted: Mon Aug 22, 2005 8:00 pm
by feyd
or just do....

Code: Select all

SELECT *, DATE_FORMAT(ADDDATE(last_login, INTERVAL 16 HOUR), '%d-%b-%Y %r') AS last_login FROM table...

Posted: Mon Aug 22, 2005 8:35 pm
by Jim_Bo
Hi,

Oh that crossed my mind but assumed it wouldnt work ..

Cheers