Time Stamp Analysis

[#1]

Hi I have the follwoing time stamp loading from a txt file.

timestamp(dateTimeOrigination/86400+makedate(1970,1,1)+interval#(-5,'h')) as TimeStamp

the output of it is as follow: M/D/YYYY H:MM:SS PM or AM

how can I separte the Month by itself  on a month field and the time on a different field as well?

Thxs,

Badr

[#2]

Help Please!

[Jason_Michaelides]

Try:

Month(timestamp(dateTimeOrigination/86400+makedate(1970,1,1)+interval#(-5,'h'))) as Month,

Time(Frac(timestamp(dateTimeOrigination/86400+makedate(1970,1,1)+interval#(-5,'h')))) as Time

Hope this helps,

Jason

[#4]

That didn't work.

Thxs,

[Jason_Michaelides]

Please give some more detail - what didn't work, exactly?  Or, better still, post your app.