Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, how can i convert date in script from 08-OCT-10 to 08.11.2011 ?
Thanks
Try using date format function DATE(), like
LOAD ...
Date(YOURDATEFIELD,'DD.MM.YYYY') as NEWDATEFIELD,
...
check out format codes.
Other way is changing the system variables DateFormat at the top of your script.
Hope this helps,
Stefan
Try using date format function DATE(), like
LOAD ...
Date(YOURDATEFIELD,'DD.MM.YYYY') as NEWDATEFIELD,
...
check out format codes.
Other way is changing the system variables DateFormat at the top of your script.
Hope this helps,
Stefan
Thanks, That works fine.