Date Time Issue

ankitab918 over 8 years ago

When I am printing now(), it's returning 9/8/2016 3:11 AM EDT.
But for hour(now()), it's returning: 7
totime(now()): 7:11 AM
Default user timezone is UTC-5:00(Eastern Time)
How do I get the correct hour for the present time?

Discussion posts and replies are publicly visible

Top Replies

pavithrac over 8 years ago +1

It seems that hour function is not working with datetime time stamp however it accepts time/datetime as per the documentation and also it seems that hour function is working if just time is passed to it…

Parents

0 vimalkumars
Certified Lead Developer
over 8 years ago

Can you try the below expression:
hour(totime(local(now())))
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Reject Answer

Cancel

Reply

0 vimalkumars
Certified Lead Developer
over 8 years ago

Can you try the below expression:
hour(totime(local(now())))
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Reject Answer

Cancel

Children

No Data