Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
i want to load always all fields from tables by
Load * from...
But 1 field must be change to a date. What is the best practice for it?
regards,
sam
LOAD *,
Date(mydate) as mydate2
FROM....;
DROP FIELD mydate;
RENAME FIELD mydate2 TO mydate;
-Rob
LOAD *,
Date(mydate) as mydate2
FROM....;
DROP FIELD mydate;
RENAME FIELD mydate2 TO mydate;
-Rob
Load *,
Date(MonthStart(DateField), 'MMM`YY') as MonthYear
from...
Hope you enjoy my experience.
You are too fast in answers. Well done jedi-knight.