Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Help Please!
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
That didn't work.
Thxs,
Please give some more detail - what didn't work, exactly? Or, better still, post your app.