date format outside of query
Posted: Mon Aug 22, 2005 7:56 pm
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:
Cheers
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_loginCheers