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

It's not just the hour function, any random hard coded value is also changed to a different time in the datetime function. For eg.,
datetime(2016,9,8,4,30,30,30) returns 9/8/2016 12:30 AM EDT
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 ankitab918 over 8 years ago

It's not just the hour function, any random hard coded value is also changed to a different time in the datetime function. For eg.,
datetime(2016,9,8,4,30,30,30) returns 9/8/2016 12:30 AM EDT
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data