Date Time Issue

ankitab918 over 7 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 7 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 ankitab918 over 7 years ago

Thanks, I guess userdatetime() solves the issue :)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 ankitab918 over 7 years ago

Thanks, I guess userdatetime() solves the issue :)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data