Date/time format

[#1]

Hi all,

I'm trying to format the following date-time format, but nothing so far has worked.

Current format . eg. :31/AUG/11 01:57:39.000000000 PM

I've tried this expression with no luck :  date(floor(timestamp#(CALL_DATETIME,'DD/MMM/YY hh:mm:ss')),'DD/M/YYYY') as CallDateTime

Any ideas on how to achieve the date format : DD/MM/YYYY hh:mm:ss ?

Many thanks

[sivarajs · Accepted solution]

=date(date#('31/AUG/11 01:57:39.000000000 PM','DD/MMM/YYYY hh:mm:ss.[fff] TT'),'DD/MM/YYYY hh:mm:ss')

[#3]

Thanks Sivaraj!