Date format six digit fraction of second

[#1]

Hi Folks,

I have a updated date column with below data format:

"2014-10-09 13:19:36.657406"

Currently, I am using

Date(MAX(exUpdatedDate),'yyyy-MM-dd hh:mm:ss.fff') AS LastUpdatedDate

to store it which stores the date as below:

'2014-10-09 13:19:36.657'

When I change the format of date to Date(MAX(exUpdatedDate),'yyyy-MM-dd hh:mm:ss.ffffff') the data is getting stored as below:

'2014-10-09 13:19:36.657000'

How do I fix this?

Regards,

Pramod K

[#2]

use Date#

=Date#(('2014-10-09 13:19:36.657406'),'yyyy-MM-dd hh:mm:ss.ffffff')

[maxgro]

I think you can only use 3f   --> fff

When you add f you are just adding 0 (from my test)

Maybe by design?

=date(date#('2014-10-09 13:19:36.657406',  'YYYY-MM-DD hh:mm:ss.ffffff'), 'DD/MM/YYYY hh:mm:ss.ffffff')