CODEWITHSUNDEEP
mysql
Oğuz Çelikdemir
Oğuz Çelikdemir

Reputation: 4980

Format one column and get rest of all column by one select

I am curious that, is there any method to get all column without the write rest of all.

Like so :

SELECT DATE_FORMAT(START_DATE, '%d.%m.%Y') * FROM CUSTOMER;

What I want to do, format a single column and get all columns via one select. The reason is that, there are so many columns in the table which I do not want to write all of them each SELECT!

Upvotes: 0

Views: 899

Answers (1)

Sashi Kant
Sashi Kant

Reputation: 13465

TRy :

SELECT customer.*, DATE_FORMAT(START_DATE, '%d.%m.%Y')  FROM CUSTOMER;

Upvotes: 3

Related Questions