date

Database
Enthusiast

date

Hi all,
in my table a date column is there. It contains data as '01/12/99' '03/23/06' .
how to convert them as '01/12/1999', '03/23/2006'.
1 REPLY
Junior Supporter

Re: date

Take a look at FORMAT clause in the documentation.

BTW: DATE is DATE is DATE, FORMAT only makes it appear the way you like...

HTH.

Cheers.

Carlos.