Date conversation

[bhavvibudagam]

Hi,

       Can any one please help me

In date field  i have January 8, 2016 21:10.I have to split this Time stamp to date and time in 2 separate columns like

Date(Floor(Timestamp#(Date,'MMMM/DD/YYYY hh:mm')),'MM/DD/YYYY') as [Date1],

   Time(Frac(Timestamp#(Date,'MMMM/DD/YYYY hh:mm')),'hh:mm') as Time,

Now my doubt is how to represent  "January 8, 2016 21:10" this format of date in above functions.

January 8, 2016 21:10

January 12, 2015 20:10

[Anonymous]

'MMMM D, YYYY hh:mm'

[sunny_talwar]

May be this:

Date(Floor(Timestamp#(Date,'MMMM D, YYYY hh:mm')),'MM/DD/YYYY') as [Date1],

Time(Frac(Timestamp#(Date,'MMMM D, YYYY hh:mm')),'hh:mm') as Time,

[Chanty4u]

Date(Floor(Timestamp#(Date,'MMMM D, YYYY hh:mm')),'MM/DD/YYYY') as [Date1],

Time(Frac(Timestamp#(Date,'MMMM D, YYYY hh:mm')),'hh:mm') as Time,