Separate the date and time

[yoganantha321]

Hi,

I have column name Created_date with data as 16-MAR-14 07.36.59.000000000 PM UTC

I want to separate it as two column in script wise as

Created_date as 16-Mar-14

Created_time as 07.36.59 PM

as two different columns.

Is it possible to achieve it?

anybody can help me!

Regards,

Yoganantha Prakash G P

[sunny_talwar · Accepted solution]

Try these

=Date(Floor(Date#(Left('16-MAR-14 07.36.59.000000000 PM UTC', Index('16-MAR-14 07.36.59.000000000 PM UTC', ' ', -1)), 'DD-MMM-YY hh.mm.ss.fffffffff TT')))

=Time(Frac(Date#(Left('16-MAR-14 07.36.59.000000000 PM UTC', Index('16-MAR-14 07.36.59.000000000 PM UTC', ' ', -1)), 'DD-MMM-YY hh.mm.ss.fffffffff TT')))

[yoganantha321]

Thanks Sunny