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 pavithrac over 8 years ago

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
Can you try the below expression
hour(
text(
now(),
"hh:mm:ss"
)
)
Cancel
Vote Up +1 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 pavithrac over 8 years ago

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
Can you try the below expression
hour(
text(
now(),
"hh:mm:ss"
)
)
Cancel
Vote Up +1 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data