How to remove AM or PM from time

[Anonymous]

How Can I remove AM or PM from Time ?

[ankur_abhishek]

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 

[Anonymous]

Brother I want to Remove not replace

[ankur_abhishek]

Hi Momim

This will remove your AM & PM from time field  .

Trim(Replace( Replace(Field name, 'AM', ''),'PM',''))

[tomasz_tru]

Is it a string od timestamp? Try Purgechar(Field, 'PMA')

Tomasz

[kusumanchir]

Hi Momin,

Please try this,

Timestamp(<The timestamp field>,'DD/MM/YYYY hh:mm:ss')

[Anonymous]

Thanks

[Anonymous · Accepted solution]

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;