Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Can any one please help me to convert below date into DD/MM/YYYY format.
Thanks in advance.
May be
Date(alt(Date#(Date, 'DD/MM/YYYY'), Num#(Date)), 'DD/MM/YYYY')
try
LOAD *,
alt(date(Date#(DateField,'DD/MM/YYYY'),'DD/MM/YYYY'),date(DateField,'DD/MM/YYYY')) as DateFinal
FROM YourQVD;
May be
Date(alt(Date#(Date, 'DD/MM/YYYY'), Num#(Date)), 'DD/MM/YYYY')
try
LOAD *,
alt(date(Date#(DateField,'DD/MM/YYYY'),'DD/MM/YYYY'),date(DateField,'DD/MM/YYYY')) as DateFinal
FROM YourQVD;