Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How Can I remove AM or PM from Time ?
load *,Timestamp#(PurgeChar(StartDate,'AMP'),'DD/MM/YYYY HH:MM') as NewStartDate,
Timestamp#(PurgeChar(EndDate,'AMP'),'DD/MM/YYYY HH:MM') as NewEndDate
Resident Temp;
DROP Table Temp;
Hi Momin
Use replace function
Replace( Replace(Field name, 'AM', ''),'PM','') or you can use Left function to extract some character of values.
Regards
Ankur
Brother I want to Remove not replace
Hi Momim
This will remove your AM & PM from time field .
Trim(Replace( Replace(Field name, 'AM', ''),'PM',''))
Is it a string od timestamp? Try Purgechar(Field, 'PMA')
Tomasz
Hi Momin,
Please try this,
Timestamp(<The timestamp field>,'DD/MM/YYYY hh:mm:ss')
Thanks
load *,Timestamp#(PurgeChar(StartDate,'AMP'),'DD/MM/YYYY HH:MM') as NewStartDate,
Timestamp#(PurgeChar(EndDate,'AMP'),'DD/MM/YYYY HH:MM') as NewEndDate
Resident Temp;
DROP Table Temp;