How to fetch hours in 12 hours format in AM and PM?

[ysj]

hi

How to fetch hours in 12 and 24 formats?

[prma7799]

=TimeStamp(now(), 'MM/DD/YYYY hh:mm:ss')

[ramasaisaksoft]

Time format for 12 horus is 'h:mm:ss' and you need the 'hh:mm:ss' format, so drop one h from Timestamp# function:

Timestamp(Timestamp#(MyTimeStampFieldin12HrsFormat,'h:mm:ss TT') ,'hh:mm:ss') as MyTimeStampFieldin24HrsFormat

[ysj]

I have modified my question.could you please help me in that if you might know

[ysj]

Thank you Rama Sai,

But I am not getting expected results.

[vishsaggi]

You want a different field to get your hours ? You can try like

LOAD

     IF(hour(Timestamp(MyHour)) < 12, 'AM',

     IF(hour(Timestamp(MyHour)) >= 12 AND hour(Timestamp(MyHour)) <= 24, 'PM')) AS [AM PM];

LOAD

timestamp(floor(YourdateField) + Maketime(hour(Yourdatefield)), 'hh') as MyHour,

......

FROM yoursource;